2 Replies Latest reply on Sep 28, 2012 6:36 AM by C Palo

    Chart with Total vs one or more records

    C Palo

      Good Evening!

       

      I have to create a chart/table comparing Total vs one or more records. In order to select only certain records I need to filter the data and by filtering the data I cannot get a Grand total, just the total of filtered records...

       

      In the attached example I want to compare Brands A C and D with Grand Total of $580 not $290.

       

      Any ideas how to solve this issue?

       

      Thanks,

       

      Cristina