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
