Alternate states

[kevbrown]

I'm looking at comparison data, this week on last, or this year on last. My customer would like a straight table but would also like the ability to choose his own date range. Ideally Alternate States would do this for me, however can alternate states be produced in one straight table as they would also like a % difference column. In a nut shell, i would like to be able to have a straight table, comparing year against year for arguments sake but I can change the dates to maybe a week or data or a single day.  I also need a % difference column for the 2 dates.

Make any sense?

Kev

[sunny_talwar]

All of what you mention is possible. You can have multiple alternate states in a single straight table, but without seeing the data, it would be difficult to suggest anything. I mean I can create a sample for you, but it would be all my guesswork which may or may not fit your requirement perfectly. So in order to avoid any rework, I am going to ask you to provide some raw data (may be dummy) which is similar to your original data and provide information about what will be the dimension on which we would be seeing all this.

Best,

Sunny

[kevbrown]

in a qvw?

[sunny_talwar]

qvw would be ideal

[kevbrown]

I would like to see a comparison of dates, so that could be weeks or months or years, with a %Diff to calculate the difference between those weeks or months or years

Kev

[sunny_talwar · Accepted solution]

Can you try this and see if this is what you want?

[kevbrown]

That's superb, thanks Sunny.