3 Replies Latest reply on Dec 26, 2018 12:25 PM by Deepak Rai

    How do I calculate a table pct difference between members of a dimension

    John Wilson

      Hi

      I am looking at a cross tab of dimensions using pct of total (table down) for gender.  What I want is the calculation that shows the difference in pct by gender

      So for example

      CODE     Gender

                      M         F                                             THE VALUE I AM SEEKING

      1               22.5%     16.4%                                          22.5 - 16.4

      2               19.2%     21.5%                                           19.2 - 21.5

      *Pctgs based on table down pct of total

      Note that this is an example...I have attached a twbx