Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview Friends
I hava a data as fallows
Jan | Feb | Mar | Apr | ........ | Dec | |
Count1 | 200 | 120 | 235 | 460 | ......... | 301 |
Count2 | 150 | 112 | 183 | 340 | ...... | 209 |
Count3 | 120 | 130 | 139 | 120 | .... | 127 |
YTD | 470 | 362 | 557 | 920 | 637 |
Count1 = Count(Field)
Count2 = Count(Field)
Count3 = Count(Field)
with different conditions
YTD = Sum(Count1, Count2, Count3)
but I want as fallows
Jan | Feb | Mar | Apr | ........ | Dec | YTD | |
Count1 | 200 | 120 | 235 | 460 | ......... | 301 | 1316 |
Count2 | 150 | 112 | 183 | 340 | ...... | 209 | 994 |
Count3 | 120 | 130 | 139 | 120 | .... | 127 | 636et |
I can get this using partial ''sum option with Month'' but it always comes 'TOTAL' as Title , different colour, bold font etc
but I want just YTD as title same as other expressions
I tried count1, count2.count2 expressions horizontally , YTD expression as vertically but its not coming all expressions either coming vertically or horizontally .
can we make some expressions vertically and some expressions horizontally in pivot table please advice me
Use partial Sum and change the label for TOTAL..See below
Also check this link.Pivot Table SubTotals when a Dimension determines Expression Calculation .Good example provided by stevedark for customising Pivot table Totals
Thanks You,
but is it doable , like some expressions as vertically , some as horizontally in single pivot table
Regards
NKummari
NO for Expressions.But YES for Dimensions
Check this it may help you how to get one expression horizontal and one vertical in pivot table?