4 Replies Latest reply on Jan 17, 2019 8:36 AM by Yingying Zeng

    Additional Aggregate column Along with Text table

    Yingying Zeng

      Aggregate columns along with Text box.png

       

      Dear Community,

       

      I have trouble to add additional aggregated column between the LOD Discount  and the grand total number as the above the image with the attached dashboard.

      The additional aggregated columns is calculated by Discount * Grand total for each product

      Can any one advise whether there is a way to do it tableau?

       

      The issue I have is that when I calculated discount * Grand Total. It gave me multiply rows instead of one as below in my data. It seems that when I try to drag the aggregated columns in, it breaks down as a dimension

       

       

      multirows.png