Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Tresesco,
Will your approach will work only if all the fields are from the same table?
Thanks,
Gautham
@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
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.