2 Replies Latest reply on Oct 28, 2014 7:41 AM by Ulrik Gregersen

    How to get one dimension to ignore another dimension?

    Ulrik Gregersen

      Hi,

       

      I am trying to make a create a financial review report which includes the following columns:

       

      YTD 2013, which is Year(gl posting date) = (accounting year (2014))-1 and Month(gl posting date) <= accounting month (september)

      Aug 2013, which is Year(gl posting date) = (accounting year)-1 and Month(gl posting date) = accounting month-1

      Sep 2013, which is Year(gl posting date) = (accounting year)-1 and Month(gl posting date) = accounting month

       

      And the same with 2014 etc. in order to make comparison.

       

      On rows I need to create calculated field with key ratios etc., so I figure that I need to create dimensions for my columns.

       

      My problem is, that when I define "Aug 2013" as a dimension Tableau subtracts the august amounts from my YTD 2013 and the same with september. So the YTD 2013 becomes January to July and not January to September, which is the result that I need.

       

      How to make the YTD 2013 to include aug and sep even though aug and sep are shown seperately?

       

      I have attached an excel pic for an example.

       

      Br,

       

      Ulrik