I have charts and tables that have dynamic values based on parameter selection. When a user changes the parameter the values for the chart change (yes, no, more than 1, etc.) The users would like to hide (not filter) the values as needed. For example, they only want to SEE the 'Yes' portion of the/chart/table, then the 'No' portion, but not filter the data so the data remains the same. Attached is the workbook. The current filter that I dont want to filter but should just hide the detail is [Calc_ChartGroup]
This uses public available data.
@Andrew Piskorowski (Member)
Hi, you may create a calculated field like:
SUM([_Llcpwt])/SUM({FIXED
[Anydis],
[_Racegr4],
[Calc_Breakdown1],
[Calc_Decide],
[Calc_DisabilityCog],
[Calc_Any Disability],
[Calc_DisabilityAny],
[Calc_DisabilityAny (copy)]
:SUM([_Llcpwt])})
Also, you would need to add the chart group filter to context:
Attached you will find the workbook:
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
