Set a conditional per dimension without having dimension in the chart?

[#1]

Hello,

I'm trying to perform an if/then statement against a list of dimension values and then get the total of those values.  However, the tricky part is that I don't want all those dimension rows showing in the table... I'd like it to be a summary/totals table.

I have attached an example.  You can see in the DETAILS table the calculation and totalling works fine becuase all the dimension values are in each row (dimension  = ACCOUNT).

However when I try and SUMMARY table and try to display *just the total' of the rows of the DETAILS TABLE, it is not considering the per row/per dimension value calculation becuase that dimension is not included in the table.

So in the attached example I'm trying to get $38,500 to display in the SUMMARY table.

Any ideas?

Thanks.

[CELAMBARASAN]

Hi,

Use Aggr function based on the dimension you used in the detail chart for summary.

Check with this expression

Sum(Aggr(if (sum ({$< YEAR = {$(=max(YEAR))}>}[INVOICE])= 0,

sum ({$< YEAR = {$(=max(YEAR)-1)}>}[PAYMENT])), ACCOUNT))

Hope it helps

Celambarasan