SuccessFactors Canvas Report and Filters/Wage Types

[former_member109239]

Hi all,

I'm creating a report with the intention to show 4 different Wage Type and their associated amount. For example, Employee John has WT 1, WT 2 and WT 3 under compensation and recurring allowances and Employee Tom has WT 1, WT 2, WT 3 and WT 4.

If I were to only insert a Wage Type Filter and generate the report, it would have 3 lines of output for John and 4 lines for Tom. Sample below -

I found out about the table duplication method and inserted the respective filters for WT 1, 2, 3 and 4. The output is then missing John.

How do I go about doing it so that John will appear as well? The expected output as below

Appreciate any advice that can be provided to address this.

Regards

Constans

[Charan_Aka]

Hi Jun,

The table duplication and adding filters to respective tables should bring what you are expecting. Please check if you are adding any other query filter other than table filters.

Regards,

Charan