Comparing Data from different dates in one table

[#1]

Hello,

I was wondering if someone can help me to solve and issue between comparing Data from different dates but in the same table.

I got my ammount spent from 2014 to 2015. Currently i have my calendar and i can choose any date from 2014 and 2015.

For example i can know the ammount spent from 23 of feb 2014 to the 31 of march 2014.

What im trying to do now, is a way i can select a couple of date range, and get the data comparison.

This information would be displayed on the same pivot table, and i would add expression that represent the variation of both dates.

For example

I have:

Dimensions	Amount
Dimension 1	24548
Dimension 2	4578
Dimension 3	569
Dimension 4	45688

This are the values selected from any Date or range of dates.

And i want:

Dimensions	Amount	Amount2
Dimension 1	24548	20482
Dimension 2	4578	3687
Dimension 3	569	452
Dimension 4	45688	47854

In this example, the first Amount is the same of the previous example, but the Amount2, comes from a different date selection.

This is so i can compare, for example, january 2014 with feb 2014, or 25-27 march 2015 with 21-23 feb 2014.

Is there a way to do this?

thanks for the help,

KR

[MK_QSL · Accepted solution]

Use Alternate State

[#3]

O i didnt knew about this feature, thanks for the tip.