Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.

Is possible to generate above chart in below format using straight table

yeah go to below link
if I understand your questiom try with dimension limit

thanx masimmo,,but in my case it give wrong result means it correct summation
Hi,
Post some sample data ......
Are some columns correct and some not?
Is there is any to represent a chart in this format
Retail,F&B etc are the values of column Business.how we can display name of each field value in chart like retail total
As ,I am able to calculate the retail total and F&B total ,But how i can display name total or F&B total

see the attachment for the reference

I want to show advertisement total instead of Business total
Hi Shweta,
This was possible in Pivot table,
In the properties of Pivot table properties,
Under presentation check on Show Partial Sums..

Hey venkata
I have already implemented that using pivot
but my question is to display retail total,f&b total text which is the value of the column