Skip to Content
0
Former Member
Aug 08, 2007 at 11:46 AM

Hi to all

9 Views

I am a newbie in the BI..and i have some problem.

how can we get two KF in the same column?

i have 52 weeks in the column and along with that i need amount column also.how can it possible.i dont want to see weeks at amount.

<u><u>employee </u>|amount||quantity|week 1| week 2|...(like this up to 52 weeks) |total days|</u>

i took employee as the char and amount,quantity as kf.

but the problem is when i am executing the Query,weeks are comeing along with amount also.i need weeks with quantity only.

could you people please give some clues?

thanks alot