2 Replies Latest reply on Jan 16, 2018 3:09 PM by Geetika Mital

    STATIC COLUMN WITH DYNAMIC COLUMNS IN ONE TABLE

    Geetika Mital

      0down votefavorite

       

       

      I am building a tableau dashboard which has month, region, and account type filter. (Account type can have only two values either New account or old account)

      The table in the report should have the following columns:

      Month, Region, Clicks, Signups.

      Now the issue is clicks are independent of the account type and signups is dependent on the account type.

      I am required to create a static clicks columns i.e when a user filters on account type then only signups column numbers change but clicks remain the same.

      I have tried multiple ways to create this table but I am unable to reach a solution to this. I also tried creating two workbooks- one with just a clicks column and the other workbook with rest of the columns. After which, I pasted them together side by side in a dashboard. But the formatting looks extremly off and not professional.

      Could you please guide me as to how I can achieve this?