Detail report

[paulwalker]

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

[robert_mika]

If you clear the Range, that will show both values.

I believe this id down to the way your variable works

[paulwalker]

HI Robert,

When i am clear ranges working fine for me.

But users want to export summarized report, based on selection ranges.

[Anonymous]

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

[sunny_talwar]

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))))