none
ParallelPeriod delivers wrong total with active filters RRS feed

  • Question

  • I'm using the parallelperiod function to get the sales from the previous year.  If I filter/remove a quater (e.g. 2008-Q4) from the analysis, the actual sales are reduced by the respective value, but the last years sales does not change anyway. technically it is correct, but it gives the impression, that the last years sales measure is summed up incorrectly:

                    actual   lastyear
    2007 Q1    2          1
    2007 Q2    2          1
    2007 Q3    2          1
    2007 Q4    2          1
    2007 Total 8          4
    2008 Q1    3          2
    2008 Q2    3          2
    2008 Q3    3          2
    2008 Total 9          8

    is there a way to get the acutal displayed sum of 6 displayed in this example?
    Tuesday, November 24, 2009 4:55 PM

Answers

  • This recent Forum thread discusses a possible approach to such a scenario, depending on the OLAP client tool:

    work with only selected members


    - Deepak
    • Marked as answer by redballon Wednesday, November 25, 2009 9:06 AM
    Tuesday, November 24, 2009 8:10 PM
    Moderator