Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ! Dear Fellows
I have a problem of restricted total amount .
The Chart dimension is period .
The expression like 'sum({$< PeriodID = { 4,5,6 } > total Amount ) ' including all amount value .
Is there good way to solve this problem ?
The data is
Period Amount
1 100
2 200
3 300
4 400
5 500
6 600
The Target is
Period Amout Total Rate
4 400 1500 4/15
5 500 1500 5/15
6 600 1500 6/15
I am not sure I understand what are you looking for? You don't want to use this to get Rate?
Sum({$<PeriodID = { 4,5,6 }>}Amount)/Sum(TOTAL {$<PeriodID = { 4,5,6 }>}Amount)
Can you please clarify what exactly is the concern here?
I am not sure I understand what are you looking for? You don't want to use this to get Rate?
Sum({$<PeriodID = { 4,5,6 }>}Amount)/Sum(TOTAL {$<PeriodID = { 4,5,6 }>}Amount)
Can you please clarify what exactly is the concern here?
What do you want here,
You want show two dimensions along with 2 Expressions which is Total and Rate or what?
Please effort here to post As soon as you can ...!
I am sorry to say ' Thank you ' lately .
The sample is too simplified . It is my mistakes.
The real problem was denominator is Aggr(count ( total {$<PeriodID = { 4,5,6 }>}distinct Customer),periodID)
I confused that aggr problem and sum is same problem. So I posted the simplified problem.
Using Aggr function , I couldn't find the unchanged denominator value with period dimension .
Finaly I defined the variable , and fixed the problem.
Thank you quick reply and I am sorry again the late reply.
Jei H. Cho