Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have following pivot table in my QV document
MONTH | BRAN | CITY | Total |
Jan | 10,559,260 | 4,474,770 | 15,034,030 |
Feb | 10,230,246 | 3,339,784 | 13,570,030 |
Mar | 10,901,857 | 3,112,307 | 14,014,164 |
Apr | 12,596,211 | 4,771,915 | 17,368,126 |
May | 9,078,503 | 3,868,521 | 12,947,024 |
Jun | 11,159,057 | 3,839,047 | 14,998,104 |
Total | 64,525,134 | 23,406,344 | 87,931,478 |
I want to add Extra rows in the table which is like the table given below
MONTH | BRAN | CITY | Total |
Jan | 10,559,260 | 4,474,770 | 15,034,030 |
Feb | 10,230,246 | 3,339,784 | 13,570,030 |
Mar | 10,901,857 | 3,112,307 | 14,014,164 |
Apr | 12,596,211 | 4,771,915 | 17,368,126 |
May | 9,078,503 | 3,868,521 | 12,947,024 |
TOTAL | 53,366,077 | 19,567,297 | 72,933,374 |
Avg. Five Months | 10,673,215 | 3,913,459 | 14,586,675 |
Jun | 11,159,057 | 3,839,047 | 14,998,104 |
Increase(decrease) | 485,842 | -74,412 | 411,429 |
Is this possible? If so pls help me to do it
You can try this technique: How IntervalMatch Solved My Profit and Loss Dilemma.
Otherwise the answer is No.
Might be this is Not possible
You need to add these values to your MONTH field (maybe you creates an extra field for these pivot to don't disturb your normal field view and behaviour) with a concatenate load:
concatenate (Calendar)
load * Inline [
MONTH
TOTAL
Avg. Five Months
];
and within the expressions you need to query the value of the MONTH field with an expression like:
pick(match(MONTH, 'TOTAL', 'Avg. Five Months') + 1,
sum(value),
sum(TOTAL value),
avg(aggr(sum(TOTAL value), MonthNum)))
I think you will need some adjustements to the expressions but in general these approach will work
- Marcus
Thanks all for your replies helping me. I am working on your suggestions