Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Use calculate to work out previous years instance

Hi,   I am wanting to use a variance against the previous year but I am unable to do same period last year as I am going of a custom column called instance rather an a date.   The instance is the...
Need Help
Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Hi Anonymous,

 

My understanding you trying to see the difference in sales between this year and the last year. I have replicated what you have you can find it in my library by clicking on the link below:

 

Hope that helps.

 

Regards

Abduvali

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Abduvali,

     

    Thanks for that, unfortunatly not what I am loking for.

     

    I need to find a way to use the item selected from the slicer in a measure to calculate the sales against the previous year but what has been selected in the slicer.

     

    Thanks

     

    C