Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The following expression doesn't work for me:
sum( Qty*Carts_Per_Item) /
sum(TOTAL <Style> Qty*Carts_Per_Item)
Any idea why?
Thanks!
I am getting it with no problem
Hi Sunny,
I have posted the model..
Maybe I miss something silly..
Thanks for your kind help!
Please look at my model. It has dim B too..
You have used B as dimension, do you really need it?
Unfortunately, yes..
It has to look like that:
A | B | SUM | |
Cl | Bold 1 | 14660 | 33% |
Cl | Regular 1 | 37362 | 33% |
Fl | Smooth | 10222 | 19% |
Fl | Summer | 12418 | 19% |
Fl | Mint | 8138 | 19% |
Me | Smooth | 6322 | 48% |
Me | Bold | 17352 | 48% |
Me | Regular | 52939 | 48% |
Try this
SUM(TOTAL <A> SUM)/
SUM(TOTAL SUM)
well, your magic touch 🙂
Thanks!
I still have to check now with multiplying by a field from another table.. so
will mark as helpful for the meantime 🙂