3 Replies Latest reply: Nov 2, 2010 7:32 PM by John Witherspoon RSS

    Bar chart with 2 dimensions (one calculated)


      How can I achieve this bar chart (stacked)

      I have 2 dimensions :

      the first is calculated

      =if( TrancheHebdo <= 9 , 'Lundi à Vendredi' , if( TrancheHebdo=10 , 'Samedi Matin' , 'Samedi Après-Midi'))

      The second is DOMAIN

      The expression should be the % of sales for each value of DOMAIN

      I know how to achieve is the first dimension is not calculated = Sum( Sales) / Sum( <MyFirtsDim > All Sales)

      But with the formula I can't figure out to get the correct result. Of course, I don't want to create the dimension is the script.

      Thanks for any help