Dear QVExpert,
I have requirement where I have a table which contains Forecast Category & Direct reportees Name as a Dimension & One Expression which shows the Revenue. So if I select Manager name & month Year as a selection then I want to display the ppl under him & their Revenue, My problem is only when I select manager & month if there is no data associated with that direct reportees then it is showing null value in the dimension, so instead of that it should show all Dimension data with 0 values as below table.
Note: I want the following Output in Pivot Table.
| Forecast Category | Direct Reportees Name | Jon | Tom |
| Close | | 0 | 0 |
| Bestcase | | 0 | 0 |
| Commit | | 0 | 0 |
| Pipeline | | 0 | 0 |
Currently due to no data present its showing like this,
| Forecast Category | Direct Reportees Name | - |
| - | | 0 |
Can you please guide me how can I achieve this.
Thanks & Regards,
Nirav Bhimani
