Sum of Quarters

[#1]

Hi All,

I have a Quarter field (Q1, Q2, Q3,Q4) which I am using as Dimension in a Pivot Table.

I want another field 'FY' to be displayed as sum of all the Quarters (Q1+Q2+Q3+Q4)

\

Power
Revenue £'000s	Q1	Q2	Q3	Q4	FY
Known New Business;
> Closed Won - Booked	22	0	0	0	22
> Closed Won - To be booked	805	0	0	0	805
Weighted Pipeline	476	311	178	221	1,185
Pipeline Gap (Actuals Vs Budget)	(596)	396	528	468	795
New Business Forecast	597	693	693	675	2,658
New Business Budget	707	707	707	688	2,808
New Business PY	127	942	194	461	1,724
Premium $m	Q1	Q2	Q3	Q4	FY
Known New Business;
> Closed Won – Booked	7	0	0	0	7
> Closed Won - To be booked	2	0	3	3	8
Weighted Pipeline	10	7	12	7	35
Pipeline Gap (Actuals Vs Budget)	(19)	(7)	(15)	(9)	(50)
New Business Actuals	19	7	15	9	50
New Business Budget	NA	NA	NA	NA	NA
New Business PY	44	6	12	27	89

Please advise.

Thanks In Advance

Ashish

[sasikanth · Accepted solution]

Did you enable the Partial sum option.

[Gysbert_Wassenaar]

In my experience a good solution is to create a new field in the script with a small inline table:

ExtraField:

LOAD * INLINE [

Quarter, Period

Q1, Q1

Q2, Q2

Q3, Q3

Q4, Q4

Q1, FY

Q2, FY

Q3, FY

Q4, FY

];

You can then use the field Period as dimension in your pivot table instead of the field Quarter.

[#4]

Hi Sasikanth,

Thanks for your reply. I have enabled the Partial Sum option and it's working as expected.

But there is one problem for the Partial Sum field (FY),the font color of the field as well as the values are in Bold and the background of this column in Grey. 

I want the field values to be displayed in regular color and the background should be white.

Please advise.

Thanks & Regards,

Ashish

[sasikanth]

Hi
You can cusomize the font color and backgroung

CTRL+G --> Custom format cell

there you can change