2 totals by a dimension value

[#1]

Hi All,

Is it possible to achieve this kind of totaling in Pivot charts?

Whats needed:

What i have now in Qlikview:

Let me know.

Thank you Guys.

[Chanty4u]

chk dis

Grand total

Pivot Table sub total and grand total

[sunny_talwar]

Would you be able to share a sample?

[#4]

stalwar1‌ Refere the attached images above.

in 1st image, we have 8 Cluster + a license fee values. So, i want to add up all these 8 clusters( as total) and add the license for this total and show as a Grand total row(refer the 2nd image).

Sample file with data attached.

[#5]

Hi Sunny,

Refer the attached images above.

in 1st image, we have 8 Cluster + a license fee values. So, i want to add up all these 8 clusters( as total) and add the license for this total and show as a Grand total row(refer the 2nd image).

Sample file with data attached.

[#6]

Hi Chanty,

Your reference to this problem is different. My requirement is not same.

But, thanks for the time.