What are different Comparative Analysis formula?

[#1]

Hi,

I have problem on setting up formulas for comparative analysis? Anyone can help me? Please let me know how to get the following...

• Year-to-date vs. Last-Year-to-Date
• Month-to-date vs. Last-Month-to-date
• This Year vs. Last Year
• This Month vs. Last Month

Thanks,

Bill

[#2]

I'm not sure if this has to be done with comparative analysis.

I can imagine that YTD vs last YTD can be done with setanalysis only (by substracting 1 year from the selected year for e.g.)

But if you want to do it with comparitive analysis this is possible too.

2 questions:

1: What is the issue you ran into?

2: And how should it work? (should there be one group of listboxes connected to both states? or 2 groups of listboxes (one for the normal state and one for the alternate state)

I'd like to hear

[#3]

Using gauges, getting variance (differences)