Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I encounter a problem in using aggr. Hope someone can give me some help, much appreciate!
Here is the problem.
I had used below expression in the chart:
sum(aggr(sum(quantityTickets),MasterPID,packageIdCode))
It is with one of the dimension (Year-Month) and it shows incorrect value. However, when I used the same expression in other charts, it doesn't have problem. Moreover, when I selected either one of the month, the value will automatically be corrected. See below:
Before
After
Below is the linkage between the tables. The quantity is located in table colorsizes.
Please help and thanks for all your assistance and attention first!
sum(aggr(sum(quantityTickets),[Year-Month],MasterPID,packageIdCode))
sum(aggr(sum(quantityTickets),[Year-Month],MasterPID,packageIdCode))
Oh! Thank you so much! It definitely resolved the problem! Would you please give me a little bit explanation of what the mistake I made to bring this problem in?
Every time you have an AGGR() inside an object that has dimensions, those dimensions should be into your expression, unless you know exactly what you are doing. (rare situations)
For example:
Your table has Year-Month as dimension, right? So, this field should be inside your AGGR() expression
Got it! Thank you so much!
Would you mind to close this discussion by marking Clever's answer as "correct"?
(Otherwise it is shown as "open" forever.)
Sorry about that. I should have it done. Let me know if there is still any problem.