Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have two values in [Performance] colum (Actual and Variance) and [Reason] for Variance itself.
what i am trying to do is creating a report having color in rows, performance in column, amount in values. While i created a slicer for reason.
Color Performance Reason Amount
Green Actual Actual 10
Green Variance Known 4
Green Variance Unknown 3
This looks like below report. but when I use the slicer for reason to select known variances it hides the Actual colum from pivot.
Color Actual Variance
Green 10 7
Hope i explained it well, Kindly let me know if i can use filter for varaince and ignore the selection for actual.
Color Variance
Green 4
dont want to hide Actual column over selection
Solved! Go to Solution.
Based on your description, it seems you are using a matrix and put Performace column into a Column group. So when you select Actual reason in slicer, there's no value for Variance column group so that it will not be displayed in matrix.
To keep the Performance column, I suggest you use a table instead of matrix to render your data.
Regards,
Based on your description, it seems you are using a matrix and put Performace column into a Column group. So when you select Actual reason in slicer, there's no value for Variance column group so that it will not be displayed in matrix.
To keep the Performance column, I suggest you use a table instead of matrix to render your data.
Regards,