Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing one issue.
I have 2 charts..
one is aggregated data based on Category.
and based on start and end selection, populating report.
second one is detailed report, category and subcat and so on..
Example:
1st report..
My detail report also should be same amount based these particular Categories..
in 1st report BCA=10590.
In summarized report only one record 10,000.. it should be 2 records
one for 10,000 and another 590.
PFA,
Thanks in Advance
If you clear the Range, that will show both values.
I believe this id down to the way your variable works
HI Robert,
When i am clear ranges working fine for me.
But users want to export summarized report, based on selection ranges.
Hi Paul,
Here is my suggestion, process the Category in your scripting instead of your dimension:
You will have to change the calculated dimension for Cat fiel in your Amount table. Now, in your detail report you could add an expression like the following one to show only those categories that meet your filter criteria:
=IF(vMin='--Select--' and vMax='--Select--',Cat,
IF(Aggr(Sum(Amount), Cat) >=vMin and vMax='--Select--', Cat,
if(Aggr(Sum(Amount), Cat) >= vMin and Aggr(Sum(Amount), Cat) <=vMax,Cat)))
And check the suppress when value is null option to display only the records with a value
And in your expressions, just add:
=sum(Amount)
With this you will get the following output:
Please check the attached file.
-- Karla
Paul -
You can try the following expressions:
Amount:
IF(vMin='--Select--' and vMax='--Select--', Sum(Amount),
IF(Sum(TOTAL <Cat> Amount)>=vMin and vMax='--Select--', Sum(Amount),
IF(Sum(Amount)>=vMin and Sum(Amount)<=vMax, Sum(Amount))))
%Age:
IF(vMin='--Select--' and vMax='--Select--', Sum(Amount)/sum(TOTAL Amount),
IF(Sum(TOTAL <Cat> Amount)>=vMin and vMax='--Select--', Sum(Amount)/sum(TOTAL Amount),
IF(Sum(Amount)>=vMin and Sum(Amount)<=vMax, Sum(Amount)/sum(TOTAL Amount))))