4 Replies Latest reply on Jan 31, 2018 11:20 AM by Candace Bell

    Prevent a quick filter from impacting my Table Calculation

    Sam Kpakiwa

      I want to have a quick filter...filter my data but at the same time not impact my % of Total table calculation. What's happening for me is that when I have all items selected my % of totals are fine - they show the % of total across my data set (which in this case is a pane). However, once I trigger the filter to look at a subset of my data that also impacts the table cal and changes my % of total.

       

      It's like I want to have my cake and eat it too (I know I'm sorry) but with a variable I could do that - but alas no variables here. So how do I go about doing this?

       

      Thanks in advance for your help.

       

      Sam Kpakiwa