extra Row in Pivot table

[upaliwije]

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

[Gysbert_Wassenaar]

You can try this technique: How IntervalMatch Solved My Profit and Loss Dilemma.

Otherwise the answer is No.

[Anil_Babu_Samineni]

Might be this is Not possible

[marcus_sommer]

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

[upaliwije]

Thanks all for your replies helping me. I am working on your suggestions