Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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,...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous can you put sample how your table looks like? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k  Did you ever figure out a solve?

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    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? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'm still looking for a solve on this one if anyone can help.