filter on Current year and previous year

[KKR]

Hi,

I want to present current year and previous year data on my dashboard using period Name. Could you please let me know how to write filter condition?

[anurag]

Hi @KKR Can you please review this video for your use case:

- https://youtu.be/XSw_tSu0XY4

[KKR]

@anurag  Thank you for your information, i want to represent the same data in my dashboard, could you please let me know how do you created $p1 and $p2 presentation variables?

[anurag]

@KKR 

You can create LOV for the presentation variables p1 and p2 to populate them with the period name column from a table in Incorta. 

[RADSr]

@anurag has the technique covered ( above ) but you might need some more information - do you want this to be a prompted comparison ( again, the video above ) or an ongoing running YoY comparison?   

When you say "using period name" what do you mean?  You want that to be the display?  Or that is the only indication of the year?   

The more specific the use case details the better targeted answer you'll likely get.