chart drill through

[rcorcoran]

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

[rubenmarin]

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)

[sunny_talwar · Accepted solution]

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

[rcorcoran]

Thanks Sunindia that works great

R

[sunny_talwar]

I am glad it worked.

Best,

Sunny