Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have some problem with my set analysis .
Ex: I have data with 50 dimension. Budget expression work based on particular 3 filed, (Quarter, Party, Item )
when user select the filtered in 3 filed combination. budget should work .
My Expression:
Sum({1<Year='$(=Max(Year))' >} Budget_Value)
Problem:
1. using this expression Sum({1<Year='$(=Max(Year))' >} Budget_Value)
Filtration don't affected.
2. using this expression Sum({<Year='$(=Max(Year))' >} Budget_Value)
Filtration affected. to filter the other then 3 field selection getting zero .
How to make it correct result.
Thanks,
Muni.
Hi,
Can you post the app. So that will look into the app and could get the exact requirement
Hi All,
Expression should work for Quarter,Party,Item field only, how to omit other 47 column selection ?
Hi
Anybody know the answer ?
Create Alternate States and use the alternate states for three filters and the chart
look at the sample app
Thanks Tresesco.
Try something like below:
sum({$<[$(=Concat({1<$Field-={'Quarter','Party','Item'}>}distinct $Field,']=,[')&']='),Year='$(=Max(Year))'>} Budget_Value)
I just used the approach which tresesco shared in the link.
Thanks,
Singh
Try
Sum({1<Year='$(=Max(Year))', Quarter = $::Quarter, Party = $::Party, Item = $::Item >} Budget_Value)