Forum Discussion
ppgandhi11
Helper V
Helper VMatrix Table Total Row not calculating right totals
Hi, Because some of the rows are not applicable based on the filter value, it does not show up in the matrix table. However, the total it displays at the bottom includes those missing data points...
You may use SUMX Function to add an additonal measure.
ppgandhi11Helper V
Helper Vfor example, the table is as below.
NPI # of patients seen (measure) Service
A 20 1.1
B 30 1.1
C 10 1.2
D 40 1.2
Service is a filter. When I select 1.1 service, the matrix shows below:
NPI # of patients seen
A 20
B 30
-----------------
Total 100 <-- this is incorrect. it displayed 100 because all 4 NPI totalled 100. However, the right total should have been 50. How woudl i get 50 there? (20+30)