Totals for Valuelist

[saimahasan]

Hi,

I have a problem with the valuelist used in pivot chart.

Problem statement: I have 4 dimensions (valuelist(),Fund Name, SFIN, valuelist())

Now i want the totals at the first valuelist dimension level taking the summation for the last valuelist dimension

For eg:

	Valuelist				Total
Particulars	A1		A2
	B1		B2
	Current Yr	Previous Yr	Current Yr	Previous Yr	Current Yr	Previous Yr
C
D

I want to display the last column (Total which takes the total at "Current Yr" & "Previous Yr" level)

Any help would be appreciated.

[Anil_Babu_Samineni]

Can you please provide sample

[saimahasan]

Hi,

PFA of the sample data and the application. I would like to show the totals at the end of the chart for 'Current Year' & 'Previous Year'.

Kindly suggest the solution.

[saimahasan]

stalwar1‌

please suggest..

[sunny_talwar · Accepted solution]

This?

[saimahasan]

Attaching the files again.

[sunny_talwar]

What do you want me to do with them?

[saimahasan]

If you look at my initial post i have mentioned the problem statement.

I want the totals at the valuelist dimension level but not able to achieve...

Can you suggest any solution??

[sunny_talwar]

What was wrong with my response here? Re: Totals for Valuelist

Did this not work?

[saimahasan]

It worked. Thanks a lot.