8 Replies Latest reply on Aug 15, 2018 8:38 PM by Shinichiro Murakami

    Data Padding with the Filter and Show Count

    Eva K

      Little description on what I need:

      I have a master list of Clients and Order Statuses. I am using this for Data Padding because my data set doesn't have all the Clients and Statuses.

      Requirements:

      1) Client id filter from the 'data' should be used (and NOT from the Master Client list) with Single select option and not showing 'Null' in the filter list.

      2) Show all the Workflow and Status values in the cross tab for the selected Client, wherever the Status/workflow is not present show 'Null'/Blank/0.

       

      I have attached the twbx file and used datasets.