Get previous year data from drill-down rows

[ksomosera10]

Hi,

I'm new at Qlik Sense and I'm currently working on the Pivot table. You can check this screenshot for your guide:

Required: I need to insert a measures for Prior Year Actual sales

               I need to find the percentage difference between the first measure(Actual) and the second measure(Prior Year)

Just to make my question clear, how can I have the values from 2015 including the drill-down rows into the 2016 Prior Year column.

EXAMPLE:

                    IN 2016 Prior year Measure = 62688 and so on.

Thanks in advance!

[shraddha_g]

If possible share sample app

[rahulpawarb · Accepted solution]

Hello Kevin,

Refer below given link:

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

Regards!

Rahul