Alternate States data in charts

[#1]

Hi,

I would like to compare between  identical events which take place in different calendar periods, using alternate states.

The issue I have is with displaying the dates of each state as expressions in a pivot table.

For each state, I would like to show the relevat date and the total amount ordered.

I attach the document I'm working on.

Thanks in Advance!

Anne

[ecolomer]

Try changing Only by Max

[ecolomer]

[#4]

Hi Enrique,

I need to display each date, so max and Only are not good options...

Thank you!

[ecolomer]

each date =  all possible dates?

[#6]

Yes...

[ecolomer]

Is that?

[#8]

Getting close 🙂

Since events have the same number of dates, is it possible to locate them above each other, like i tried to do?

so this way you can calculate the difference between the periods.

(the data in my example are not perfect..)

Thank you!

[ecolomer]

Change your data an explain me what is the result you need

[#10]

In general, (how) is it possible to reference alternate state data as dimensions?