Forum Discussion
Dynamically Sum Columns based on Slicer
Alright, I have several columns: Location Approved Budget SD Budget SF Budget LA Budget OC Budget IE Budget BFD Budget Approved Budget should be a meausre that sums sd, sf, la, oc, ie,...
Anonymous hey sorry for not getting back on this. I thought Ashish_Mathur already resolved it. What is the issue with the solution he provided?
parry2k It looks liek his solution splits the records into new rows, and somehow(still unexplained) manages not to duplicate the other values of the record while doing it. I don't understand how he did that. I coule be missing something simple, but he offered no further explanation.
Also, the the final product should still display multiple locations values if the record has them. I can't show:
Channel 1 IE
Channel 1 LA
It would need to be
Channel 1 IE,LA
I'm still looking for a solve on this one if anyone can help.