2 Replies Latest reply on Aug 2, 2016 7:10 AM by Luciano Vasconcelos

    How to show MTD, Daily and last 12 months MTD data in cross tab...

    santosh pokala

      How to show MTD, Daily and last 12 months MTD data in cross tab...

       

       

      I am attaching 3 excel sheets to understand back end tables structure and required report output layout....

      MTD table: It has snapshot data for each month end....(it has a  lot of metrics and I gave only 2 examples in excel sheet).

       

      Daily: Daily table has same table structure as monthly but only difference is it has snapshot of records at the end of each day...

       

      Report Layout:

      I need to each metric in a cross tab with daily, monthly, last 12months mtd data...

       

      Please let me know how to achieve this requirement in tableau...

       

      Note: I want to develop this only in worksheet in tableau workbook (I mean as one view)....