Forum Discussion
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. How do I get just the total of the lines displayed?
You may use SUMX Function to add an additonal measure.
2 Replies
ppgandhi11for 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)
v-chuncz-msftCommunity Support
You may use SUMX Function to add an additonal measure.