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

    Groups dependant expressions

    Gareth Joubert

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

       

      Product codeCustomerDatesWk1Wk2Wk3Wk4Wk5Wk6
      KG/CASEdepends on <etcetcetcetcetc
      NSV/KG100etcetcetcetcetc
      COS/KG80etcetcetcetcetc
      Profit/KG25etcetcetcetcetc


      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