Hi,
Date EMPID Pay Type Hrs
10/12/2017 100 A 1
10/11/2017 100 A 2
10/12/2017 101 B 5
10/12/2017 102 C 9
10/12/2017 103 D 13
10/12/2017 105 E 17
10/1/2018 100 A
10/1/2018 101 B 21
10/1/2018 102 C
10/1/2018 103 D 27
10/1/2018 105 E 31
I used date prompt has Date and Column - Paytype, row - EMPID and Measures - Hrs
when i trying to run I'm getting the output which have values and without values are displayed and when my client is trying is displaying values which has hrs and rest of columns are hiding.
If the give the Date prompt 10/1/2018
i'm getting A-E Pay types but for my client B,D,E.
Please let me know do i need to chance any properties.
Thank you in Advance.