Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all...
i hve data with rows like'
Revenue bucket | ForecsatRev | Region | Customer | Comments | RevTerms | Period | Week |
firm | 123 | a | A | xxf | abcd | 15_Q4 | 33 |
qtdsles | 122 | b | B | gdsg | abcd | 13_Q3 | 34 |
risk_h | 34 | c | C | fff | dsff | 11_Q3 | 35 |
risk_l | 55 | d | D | g | ggd | 10_Q4 | 33 |
ups_h | 66 | s | E | gg | hf | 11_Q3 | 34 |
ups_l | 78 | e | F | gsf | hh | 15_Q3 | 35 |
firm | 123 | a | A | xxf | abcd | 15_Q4 | 33 |
qtdsles | 122 | b | B | gdsg | abcd | 13_Q3 | 34 |
risk_h | 34 | c | C | fff | dsff | 11_Q3 | 35 |
risk_l | 55 | d | D | g | ggd | 10_Q4 | 33 |
ups_h | 66 | s | E | gg | hf | 11_Q3 | 34 |
ups_l | 78 | e | F | gsf | hh | 15_Q3 | 35 |
i hve data above ...but i want oonly WEEK row as
Revenue bucket | ForecsatRev | Region | Customer | Comments | RevTerms | Period | 33 34 35 |
and Revenue bucket is my measure...? i want that values in week column like pivot table
how can i achieve dis in pivot table?
like that suresh
but user need.....wen he clicks on 33...he wants lik +symbol to get the revenue bucket values
see the attached
no kush....
i want wen i clik on 33 it will expand the values within that revenue bucket
sorry sureshqv but it is not possible expand the values within that revenue bucket..
Hmm thnx ahmar
May be this?