6 Replies Latest reply: Oct 12, 2017 11:54 AM by becki kain RSS

    Total which does not change

    becki kain

      I need to calculate the total volume of sales, by each time period and i need that value of those to not change, if the user selects a segment of the vehicle types.  if i use =sum({<[TP]={$(TP1)}>} ALL Volume), where TP1 is a user entered value, I get an unchanging sum of all volumes in the data set, for all time periods, not the sum volume of all in the set of TP1. if i do this =sum(ALL{<[TP]={$(TP1)}>} Volume), the sum volume is changed, when the user clicks on a vehicle type.  that is also the case with =sum({<[TP]={$(TP1)}>} TOTAL Volume) no matter when I put the word TOTAL.  How do I sum the total volume of sales, for each time period, without it changing if the user selects a vehicle segment?


      thanks


      becki kain