3 Replies Latest reply on Feb 7, 2017 11:18 PM by Jose Silva

    ACCUMULATED SALES WON'T BEING AFFECTED BY TIME FILTERS

    Jose Silva

      Hi everyone!

       

      I would like to do a chart showing the total sales of the concepts A and B by country and filtered by week number.

       

      The problem is that I need to show current sales by week (selected by filtering) and at the same time one column with the accumulate sales (taking the previous weeks). If I filter a specific week, the accumulate sales won’t be showed.

       

      How can I do for that the accumulative sales won’t be affected by the filter?

       

      I use as well Running Sum and Totals but it does not make any sense.

       

      I took as alternative duplicating the data base and calculate the accumulated sales using the data from the duplicate DB and using another filter (just for the second DB), it works! But the client wants to use just one filter at the same time.

       

      Sales Accum.png

       

       

      Can anybody help me with this?

       

      Many thanks!!!

       

      José