Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
another query on a chart.
The chart attached is showing data this year v previous 2 years but it is showing a total for all areas.
I need it to show total for each area if they are selected from the area list box.
Any help appreciated
R
Your expression: =Sum({1<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY))'}>}ActualValue)
and [ImmVacc 117] seems to be blank in 2015 and you are using the set analysis statement to include only [ImmVacc 117] which equal 12.
Otherwise to let your selections in Area work you can do something like this:
=Sum({1<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY))'}, RDODesc = p(RDODesc)>}ActualValue)
HTH
Best,
Sunny
Hi R, you can add a TOTAL clause per RDODesc and remove the {1} that ignores all selections, ie:
=Sum(TOTAL <RDODesc> {<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY)-1)'}>}ActualValue)
Your expression: =Sum({1<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY))'}>}ActualValue)
and [ImmVacc 117] seems to be blank in 2015 and you are using the set analysis statement to include only [ImmVacc 117] which equal 12.
Otherwise to let your selections in Area work you can do something like this:
=Sum({1<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY))'}, RDODesc = p(RDODesc)>}ActualValue)
HTH
Best,
Sunny
Thanks Sunindia that works great
R
I am glad it worked.
Best,
Sunny