1 Reply Latest reply on Sep 12, 2016 7:54 AM by lenaic.ridinger

    Action filter on Subtotal and Grand total for further drill down of data

    Mazhar Sayed

      Is there any way to apply action filter on Subtotal and Grand total for further drill down of data, I have tried creating separate calculations for sub totals and have applied it on dashboard as floating  but that disturbs the layout if there is no data in the row, so that looks like

       

        • 1. Re: Action filter on Subtotal and Grand total for further drill down of data

          Hi Mazhar Sayed,

           

          The basic issue is that there doesn't seem to be any data for those combinations of dimensions you are using, and Tableau doesn't make up data when there isn't any. "No data" is different from Null, and that's why the ISNULL() function is failing.

           

          However, we can tell Tableau to generate a null when there isn't any data, and that's using the following table calculation: LOOKUP(SUM([YourDimension]),0).

           

          This table calc returns SUM([YourDimension]) for the current row, and Null when no value is found. Then you can wrap that in the IIF(ISNULL()) operation to return 0 or a value. alternatively, you could just do the lookup and then Format the calculation to set 0 to be the Text for Special Values.

           

          Let me know if this solved the issue you're experiencing.

          1 of 1 people found this helpful