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?