Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Same Peeriod Last Year Filtered by Many Columns

Hi,   I am trying to calculate the sales same time last year filtered by about 20 columns. What is the best way to do this? I been using caculate sum, sameperiodlastyear, and allexcept (with the 20...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Find the file again

     

    if you need more help make me @

    Appreciate your Kudos.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler below is the emulated data. I need to get the sales for the same time last year filtered by the different columns (i.e. product, currency, country, etc.)

     

    Thank you so much for your help!

     

     

     

    CountryProductCurrency PurchaseMonthSales
    USAAUSD1/1/20203000
    USAAUSD1/1/20192000
    FranceBEUR1/1/20201000
    FranceBEUR1/1/2019500
    USABEUR1/1/20201500
    USABEUR1/1/20194000
    FranceCEUR1/1/2020750
    FranceCEUR1/1/2019200

     

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        amitchandak thank you for your response and work.

         

        If you had to create another column in the table called Sales LY rather than measure would you do it differently?