Comparing Data from different dates in one table

Mon, 09 Nov 2015 19:50:18 GMT

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:

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

And i want:

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,

Re: Comparing Data from different dates in one table

MK_QSL — Mon, 09 Nov 2015 19:51:16 GMT

Use Alternate State

Mon, 09 Nov 2015 21:59:07 GMT

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