Get instant live expert help on I need help with pivot table in r

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need to lock a table reference in an index, match function. E.g. =INDEX(R[241]C[-8]:R[377]C[-5],MATCH(RC[-8],R[241]C[-8]:R[377]C[-8],0)+0,4) I do not want to change R[241]C[-8]:R[377]C[-5] or R[241]C[-8]:R[377]C[-8] when I drag the formula down
Solved by X. H. in 23 mins
I'm trying to total the values in a pivot table. Essentially i want another value in the pivot table which displays the sum of the other pivot table columns.
Solved by V. D. in 18 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins
Grouping not available in pivot table and cannot have more than one pivot table in one worksheet
Solved by O. E. in 26 mins
I have problems with my pivot table . Require an expert in pivot table
Solved by K. C. in 21 mins