Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Variance Between Years

Hi,   I have 6-7 tables with different KPIs (Sales, distribution etc for year 2017 and 2018 calculated at Month,YTD and QTD. Example below   All i need is to show the variance between the years b...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Any help?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have marked as solved by mistake. I am still looking for the way out

 

Greg_DecklerCan anyone please help me out here, i am almost there. I have everything i need for the dashboard. ALl i need is to find the way to calcualte vairiance and variance%

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Greg_Deckler The solution did not work as i have to create 3 measures for each KPI(30 in total) and for 3 timeperiod(Current Month, YTD and FY)

     

    Could you please suggest something optimal that i can use for all the KPI tables(Like in excel it would be 2018 Value -2017 Value)