1 Reply Latest reply on Aug 7, 2017 12:34 PM by Patrick A Van Der Hyde

    Cross tab split by 2 dims, the first 'type', second 'date', I need to display by type and date but also have a difference field

    Rich TT

      Hi,

       

      I'm trying to figure out how to do the following in Tableau, the end result of how I want it to appear is below,  for every 'Type'  in this case SALE and INCOME are Typre I need to show two dates but I also need to display a 'DIF' for each type as per below.  I'm 90% of the way there and can get everything I need EXCEPT I can't figure out a way to a  'DIF' field as I require any ideas how I can do this ?    I effectively need the diff calc to be occur for each Type.

       

                                            SALE                                    INCOME

                              11 Jul 17   10 Jul 17   DIF      11 Jul 17   10 Jul 17   DIF

      UK                    5               2               3           100            90             10

      US                    15             10             5           80              60             20

       

       

      I'm not sure if this is even possible in Tableau ?

       

      thanks