3 Replies Latest reply on Feb 27, 2013 6:19 AM by stryder dsf

    calculate ratio of two values with different filter

    stryder dsf

      my problem is i need to calculate the percentage of sales of a particular state(say California) to that of the total sales of USA.

      I have a table of all the sales of stores with the states they are in. now if i apply a filter to see the stats of a particular state,I get its sum.I need to get the percentage of sales done in California to the total sales of USA but how can I get the total sales as after applying the filter the sales of other states vanish from the calculation.

      Help me please.

      thanks in advance