Pivot table Multiple Calculated rows at the End!!

[vishsaggi]

Hello Experts,

Just wondering if any help/ideas in this please.

I have a sample excel data attached. The sheet SampleOuputPivot shows the actual output i need. I am just showing only one Level in this sheet. 

The sheet FinalPPI contains the actual sample data.

I tried a lot of options but no good.

Any help much appreciated.

Please let me know if i have not made it clear.

Thanks,
V.

[Gysbert_Wassenaar]

What you want is not possible in a single pivot table. You'll have to create more charts and align them below each other.

[vishsaggi]

Thank you Gysbert for your prompt reply. I did tried that way but could not get there. Can you push some ideas on how we can achieve using multiple charts.

Many thanks,
V.

[Digvijay_Singh]

Not sure but this link matches with your heading of requirements credited to  jagan‌, sunindia‌

Re: Sum and Count at the bottom of the same table.

[vishsaggi · Accepted solution]

Hello Gysbert,

As mentioned i have to do this in Pivot table. I could able to get it using two pivot tables and my calculation included on Quartely basis. I used variables for each quarter to get the Target%, as the values in these variables has the values from a single row (i.e, from HeadCountTotals as mentioned in the excel sheet) which will be static for the calculations. Every time the Headcounttotals change, it will be reflected in the variables, so the Target% is calculated accordingly.

Thanks very much for your support and idea.

Appreciate that.

Thanks,
V.