Set analysis won't calculates per dimension or per row..so what's the solution?

[gauthamchilled]

Hi All,

I understand that Set analysis won't calculates per dimension or per row..so what's the solution? I need to calculate the following but it returns only when specific dimension is selected.

(sum(Total {$< [Year] =
, [Qtr/Yr] =
, [Month] =
, [Mth/Yr] = {">=$(=monthstart( vReportAsAt, -24 ))<=$(=monthstart( vReportAsAt, -13 ))"}
,Product=p({<Customer= {"$(=getfieldselections(Customer))"}>})
,Customer=
> }
[Customer Payment] ))

I would like to calculate the value per row so i have to remove this p({<Customer= {"$(=getfieldselections(Customer))"}>}) 

and come up with some alternative to calculate per value of dimension.

please help.

Gautham

[gauthamchilled]

Any help would be appreciated..Thanks

[gauthamchilled]

bump

[jonathandienst]

I am not sure what you are wanting to do, or how you want o change it. Field selections are global and so are set expressions.

[gauthamchilled]

Hi,

Eg:

Dimension: Insurer

Expression: (sum(Total {$< [Year] =
, [Qtr/Yr] =
, [Month] =
, [Mth/Yr] = {">=$(=monthstart( vReportAsAt, -24 ))<=$(=monthstart( vReportAsAt, -13 ))"}
,Product=p({<Insurer= {"$(=getfieldselections(Insurer))"}>})
,Insurer=
> }
[Premium] ))

Requirement: Total premium for the products per insurer(dimension value)

Product=p({<Insurer= {"$(=getfieldselections(Insurer))"}>}) --> To get same list of products owned by all other insurer . This expression works perfect if i select one insurer, if i remove the selection it is not. Because set analysis calculates per chart not per row.

Thanks,

Gautham

[tresesco]

Best way to get help in this would be sharing a sample app and explain the expected output there. 

[gauthamchilled]

Hi Tresesco & Jo,

Attached a sample document and requirement in screenshot.

[swuehl]

I can't open your sample right now, but I think one issue might be the result of the Dollar sign Expansion.

What if you try

,Product=p({<Insurer= $::Insurer>})

or just

,Product=p()

instead?

[gauthamchilled]

Hi Swuehi,

I attached a perosnal edition now

[tresesco · Accepted solution]

May be this?

Sum(Aggr( sum(TOTAL <Product> Premium),Insurer, Product))