Skip to main content

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 个回答
  1. 2020年7月21日 02:50

    To get this ...

    To get this ...

     

    I removed Calculation1 from the Rows shelf (you don't need it)

    and then I did this:

     

    2020-07-21 12_47_43-

0/9000