Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a CHART 1 , when i click on display in Org or S$ currency , the CHART able to display summary total SALES amount FOR ONE COMPANY OR ALL COMPANY.
The minute when user select the compute by eXP , the overall total amount disappear FOR 2016.
I try to modify the expression using Chart 2 by add Aggr as below :-
Sum(Aggr(Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount)/$(Columndim89)*-1/1000, $(ColumnDim101))),
But not working.
I expect chart to display 600K , which is same as Table 1.
Paul
My QV Doc
This art of the set expression looks incorrect:
<$(ColumnDim601)={$(ColumnDim601)}>
Are you sure about that? What do you expect it to look like after the $ expansion is performed.
Hi Jonathan
I think my previous example too complex . i recreate a simple one.
Below expression working fine on chart 1 :-
Sum({<eXP={"eXP"}>}Amount)*-1/$(Columndim89)
May i know how to add Aggr into above expression , so that i can comoute overall total amount.
enclosed my QV Doc
Paul