7 Replies Latest reply on Jul 18, 2017 5:19 AM by Sravan Yadav

    Creating a one vs rest average comparison with option of dynamic selection

    Abhishiek A.V

      Hi All,

       

      I have data of traffic (online traffic) for different sources (fb, twitter etc) , I want to see viz which  has one source  vs rest of the sources avg time spent , with a dynamic Source selection option.

       

       

      I am stuck on how to create a calculated field which sums up values for the rest of the sources and leave the one specified alone, I am thinking of creating 5 calculated fields each having values for the sales for that particular source  and use them in creating a final calculated field to display the above o/p, but I feel there must be better method out there.

       

      I am attaching the workbook for replication.