
Hi All,
I have split Sales into Categories. I would like to have another bar that shows the total sales in the same view. The bar will be the addition of all the the sales of the three categories - {Sum(Sales)}.
Something like this -
Total - 2297201
Furniture - 742,000
Office Supplies - 719,047
Technology - 836154
Is there a way to achieve it without doing a union or duplicating the data?
I am attaching the workbook for your kind reference.
Thank you all.
Regards,
Rishi Saka
3 个回答
To get this ...
I removed Calculation1 from the Rows shelf (you don't need it)
and then I did this: