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!
Would you be able to post a sample?
What do you mean by "it does not work"? Syntax seems to be OK, if it does not return the results you expect then as Sunny suggests post some sample data and expected results.
Are Qty and Carts_Per_Item fields in the same table?
Will try..Thanks!
Hi,
My issue is somewhere else:
I would like to have the relative quantity by dim A,
or share of A
SUM(SUM)/ SUM(TOTAL <A> SUM)
A | B | Qty | % | Total by A |
---|---|---|---|---|
159413 | 100.00% | 100% | ||
Cl | Bold 1 | 14660 | 9.20% | 28% |
Cl | Regular 1 | 37362 | 23.44% | 72% |
Fl | Mint | 8138 | 5.10% | 26% |
Fl | Smooth | 10222 | 6.41% | 33% |
Fl | Summer | 12418 | 7.79% | 40% |
Me | Bold | 17352 | 10.88% | 23% |
Me | Regular | 52939 | 33.21% | 69% |
Me | Smooth | 6322 | 3.97% | 8% |
Desired number:
Cl | 52022 | 32.63% |
Fl | 30778 | 19.31% |
Me | 76613 | 48.06% |
What am i doing wrong??
Thanks!
May be you need this
Sum(SUM)/Sum(TOTAL SUM)
Hi,
Yes, in my original model the 2 fields are in different table.
Could that cause an issue?
I simplified it just to check in the above data (sum by dim A), but it doesn't work either,,
Thanks!
No, it gives the same result as the % column..
Just Attached the data..
This is what you want to get, right?
I guess create a chart with
Dimension
A
Expression
Sum(SUM)
Sum(SUM)/Sum(TOTAL SUM)
This doesn't give you what you want, really?