How can I use filters to show sequential quarters in a table - Heat Map
920386Aug 6 2012 — edited Aug 7 2012I need to sum sales for this quarter and last quarter, then do a percent change calculation in one table in 11g
It needs to look like this:
Product X, Last Qtr, This Qtr, % Change
Prod_123, $100, $150, 50%
I've tried creating one analysis for "Last Qtr" and an identical analysis for "This Qtr" and then tried using each as a filter for the two sales amounts but it isn't working.
I know this is possible as I've seen articles written about this - but no examples or screen pictures so far.
Anybody know how to do this?
Thanks in advance!