9 Replies Latest reply: Oct 28, 2011 5:09 PM by Leonard Short RSS

    Groups dependant expressions

      Hi, I need to create a pivot table report in the following format:


      Product codeCustomerDatesWk1Wk2Wk3Wk4Wk5Wk6
      KG/CASEdepends on <etcetcetcetcetc

      The Expressions for KG is "_exp_KG", however there is no dimension that provides the required results (Smililarly "_exp_CASE" for Cases)

      If possible I would also like to make the expressions ie NSV/KG rely on the cyclic group(/chosen option).

      Do you know how I can achieve this without publishing two reports?

      Thanks, Gareth