Ad-hoc reporting, set analysis

[aisolomatin]

Hi, there!

Need your help with issue: I need to make expression, that will calc a Sum(Value) for max DateReport.

But if DateReport has added to table as Dimension, then I need to get Sum(Value) for current DateReport.

Here example. I try to use expression

=If(Dimensionality()=0,

  Sum({<DateReport={"$(=Max(Date(DateReport)))"}>}Value),

  Sum(Value)).

But problem is that it works fine for first table, but doesn't work for second.

Second table should look like this:

I need to use it in Ad-hoc reporting, so I have one table with all Dimensions (users choose Dimensions for table by themselves), and I need one expression.

[aisolomatin]

Still no, because if I remove Dimension [DateReport] from table. the result will be like this:

But I need like this (sum for max(Datereport)):

[Anil_Babu_Samineni]

Check this May be?

[vishsaggi]

Ahhh. I got it now. Its is like more dynamic addition of Dimensions. Need to work on it. I am out now will try once i come back.

[vishsaggi · Accepted solution]

Check this?