Bar chart with 2 dimensions (one calculated)

[#1]

Hi

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

Jean-Jacques

[johnw]

I tried and couldn't figure it out. What's bad about doing it in script?

[#3]

I don't have the source and the time to modify the original data (more than 100 millions records with a load time of 10 hours).

I found out a solution but I don't like it. I just created one expression for each value of DOMAIN.

Thanks anyway JohnW

JJ

[johnw]

Jean-Jacques Jesua wrote:I don't have the source and the time to modify the original data (more than 100 millions records with a load time of 10 hours).

Ouch! Yeah, my worst load is about 3 hours, and I certainly hate making modifications to that script. Sorry I couldn't think of another solution. At least you figured out something that works, even if you don't like it.