1 Reply Latest reply: Sep 23, 2017 5:19 PM by David Ganly RSS

    Set expression to get latest week Sales and Previous Quarter Sales in 2 different charts

    Monu Saraswati

      Hi Team,

       

      1. If i choose Quarter Year filter in my sheet, and depending on what Quarter Year i chose in the filter i want the latest Latest week sales of that quarter to be calculated.

       

      2. I also want previous year sales value to be calculated. Previous Quarter Sales depending on what Quarter Year filter i choose.

      Say if i choose Q3-2017 , it should display Q2-2017 Sales. If i choose Q1-2017, it should display Q4-2016.

       

      However by default point 1 should display current work week sales in graph 1 and point 2 should display previous Quarter sales in graph 2.

       

      Thanks for the help in advance