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]

Hi Tresesco,

Will your approach will work only if all the fields are from the same table?

Thanks,

Gautham

[gauthamchilled]

@tresesco  Your solution works perfect until i calculate i use set analysis for current ,previous calc or if i have to ignore selection. I am in need of using incorporating this in set..

Could you please help?

Thanks,

Gautham

[tresesco]

I am bad in imagination, or may be just don't want to put extra effort in doing so. 😋  Request you to replicate your issue in a sample app, that would help me help you.