1 Reply Latest reply on Oct 5, 2018 7:21 AM by Zhouyi Zhang

    Calculate Difference btw Distinct Counts - Dual Axis

    Dominic Beale

      I am having trouble calculating the difference between distinct counts of two different fields within the same column on a dual axis graph. I have used the Sample-superstore data to demonstrate what I am trying to do. In sheet 1, what I want to do is show the difference between the Field 1 counts vs the Field 2 counts. Example: In the consumer column on X axis, I want to show the difference between the 382 field 2 distinct costumers vs the 221 field 1 distinct customers. If it's necessary to make some sort of Fixed field that will solve this I'm open to that. Attached workbook for reference. I need to keep the parameter, formatting and grouping as it is.