1 Reply Latest reply: Dec 20, 2017 6:13 PM by Sunny Talwar RSS

    Straight Table Set Analysis

    Michael Goldshteyn

      Hello Community,

      is it possible to get a value from a dimension within a straight table to be used in the set analysis of the measure that corresponds to it?

       

      IE:

       

      The Measure is  sum({<YEAR = {2017},BRAND1={'b1'}>}NUMBER_OF_REGISTRATIONS)

       

      So the G/L measure would be for each line:

       

      Line 1: sum({<YEAR = {2017},BRAND1={'b1'}, Sales Area Code= {260}>}NUMBER_OF_REGISTRATIONS)

      Line 2: sum({<YEAR = {2017},BRAND1={'b1'}, Sales Area Code= {310}>}NUMBER_OF_REGISTRATIONS)

      etc....

       

      This is part of a larger calculation, though i need only this part to be filtered down by the specific Sales Area Code.

       

      Thoughts?