% total in straight table

[rcorcoran]

Hi I have a straight table as follows:

the % change since Feb will not show correctly.  The total mode is sum of rows but I have tried all the variations here and they won't work for me.  Any help would be appreciated

The expression for this is:

if(IsNull(Pick(Match(ValueList($(vStaffCategory)),$(vStaffCategory)),



num(((Avg({$<HRPrimaryCare={15},ReferredMM={$(#=Max({<[HRPrimaryCare]={15}>}ReferredMM))}>}ActualValue)-Avg({$<HRPrimaryCare={15},ReferredMM={$(#=Max({<[HRPrimaryCare]={15}>}ReferredMM)-1)}>}ActualValue))/Avg({$<HRPrimaryCare={15},ReferredMM={$(#=Max({<[HRPrimaryCare]={15}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Avg({$<HRPrimaryCare={16},ReferredMM={$(#=Max({<[HRPrimaryCare]={16}>}ReferredMM))}>}ActualValue)-Avg({$<HRPrimaryCare={16},ReferredMM={$(#=Max({<[HRPrimaryCare]={16}>}ReferredMM)-1)}>}ActualValue))/Avg({$<HRPrimaryCare={16},ReferredMM={$(#=Max({<[HRPrimaryCare]={16}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Avg({$<HRPrimaryCare={17},ReferredMM={$(#=Max({<[HRPrimaryCare]={17}>}ReferredMM))}>}ActualValue)-Avg({$<HRPrimaryCare={17},ReferredMM={$(#=Max({<[HRPrimaryCare]={17}>}ReferredMM)-1)}>}ActualValue))/Avg({$<HRPrimaryCare={17},ReferredMM={$(#=Max({<[HRPrimaryCare]={17}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Avg({$<HRPrimaryCare={18},ReferredMM={$(#=Max({<[HRPrimaryCare]={18}>}ReferredMM))}>}ActualValue)-Avg({$<HRPrimaryCare={18},ReferredMM={$(#=Max({<[HRPrimaryCare]={18}>}ReferredMM)-1)}>}ActualValue))/Avg({$<HRPrimaryCare={18},ReferredMM={$(#=Max({<[HRPrimaryCare]={18}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Avg({$<HRPrimaryCare={19},ReferredMM={$(#=Max({<[HRPrimaryCare]={19}>}ReferredMM))}>}ActualValue)-Avg({$<HRPrimaryCare={19},ReferredMM={$(#=Max({<[HRPrimaryCare]={19}>}ReferredMM)-1)}>}ActualValue))/Avg({$<HRPrimaryCare={19},ReferredMM={$(#=Max({<[HRPrimaryCare]={19}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Avg({$<HRPrimaryCare={20},ReferredMM={$(#=Max({<[HRPrimaryCare]={20}>}ReferredMM))}>}ActualValue)-Avg({$<HRPrimaryCare={20},ReferredMM={$(#=Max({<[HRPrimaryCare]={20}>}ReferredMM)-1)}>}ActualValue))/Avg({$<HRPrimaryCare={20},ReferredMM={$(#=Max({<[HRPrimaryCare]={20}>}ReferredMM)-1)}>}ActualValue)), vNumber2))),Null(),



Pick(Match(ValueList($(vStaffCategory)),$(vStaffCategory)),


num(((Sum({$<HRPrimaryCare={15},ReferredMM={$(#=Max({<[HRPrimaryCare]={15}>}ReferredMM))}>}ActualValue)-Sum({$<HRPrimaryCare={15},ReferredMM={$(#=Max({<[HRPrimaryCare]={15}>}ReferredMM)-1)}>}ActualValue))/Sum({$<HRPrimaryCare={15},ReferredMM={$(#=Max({<[HRPrimaryCare]={15}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Sum({$<HRPrimaryCare={16},ReferredMM={$(#=Max({<[HRPrimaryCare]={16}>}ReferredMM))}>}ActualValue)-Sum({$<HRPrimaryCare={16},ReferredMM={$(#=Max({<[HRPrimaryCare]={16}>}ReferredMM)-1)}>}ActualValue))/Sum({$<HRPrimaryCare={16},ReferredMM={$(#=Max({<[HRPrimaryCare]={16}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Sum({$<HRPrimaryCare={17},ReferredMM={$(#=Max({<[HRPrimaryCare]={17}>}ReferredMM))}>}ActualValue)-Sum({$<HRPrimaryCare={17},ReferredMM={$(#=Max({<[HRPrimaryCare]={17}>}ReferredMM)-1)}>}ActualValue))/Sum({$<HRPrimaryCare={17},ReferredMM={$(#=Max({<[HRPrimaryCare]={17}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Sum({$<HRPrimaryCare={18},ReferredMM={$(#=Max({<[HRPrimaryCare]={18}>}ReferredMM))}>}ActualValue)-Sum({$<HRPrimaryCare={18},ReferredMM={$(#=Max({<[HRPrimaryCare]={18}>}ReferredMM)-1)}>}ActualValue))/Sum({$<HRPrimaryCare={18},ReferredMM={$(#=Max({<[HRPrimaryCare]={18}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Sum({$<HRPrimaryCare={19},ReferredMM={$(#=Max({<[HRPrimaryCare]={19}>}ReferredMM))}>}ActualValue)-Sum({$<HRPrimaryCare={19},ReferredMM={$(#=Max({<[HRPrimaryCare]={19}>}ReferredMM)-1)}>}ActualValue))/Sum({$<HRPrimaryCare={19},ReferredMM={$(#=Max({<[HRPrimaryCare]={19}>}ReferredMM)-1)}>}ActualValue)), vNumber2), 
num(((Sum({$<HRPrimaryCare={20},ReferredMM={$(#=Max({<[HRPrimaryCare]={20}>}ReferredMM))}>}ActualValue)-Sum({$<HRPrimaryCare={20},ReferredMM={$(#=Max({<[HRPrimaryCare]={20}>}ReferredMM)-1)}>}ActualValue))/Sum({$<HRPrimaryCare={20},ReferredMM={$(#=Max({<[HRPrimaryCare]={20}>}ReferredMM)-1)}>}ActualValue)), vNumber2)))

[rcorcoran]

I can't get any of your suggestions to work this time but I have changed it to a pivot table and just added in totals to my variable and expressions which brings up the correct total.

thank you for all your help as usual.

[akpofureenughwu]

You are welcome, Keep sharing. Together we are stronger and better.