Percent of column total in clustered column

[Jacob441]

My table has multiple columns but I am focusing on 2 columns which have been unpivoted. Column 1 - [Meeting Room Category], Column 2 - [Value]. For "Meeting Room Category", there are only 2 distinct values - "Tables" and "People". For the Column 2, the values can be {1,2,3,4,5}. The dataset has many rows so multiple numbers in [Value] can be repeated or not appear at all.

For my clustered column chart, The X-axis is [Value], as I want to see how many times each Category appears for each Value. And the Legend is [Meeting Room Category], as I want to see the breakup between "Table" and "People". I want to see the value as a % of each of the Category, instead of the Grand Total.

What measure can I use to do this?!

[ryan_mayu]

could you pls provide some sample data and expected output?

[Jacob441]

The top 2 charts are from the bottom left chart, but with the Meeting Category of No. of seats and No. of people being filtered respectively. I am able to replicate the expected output in the matrix, and each of the charts individually, but I am unable to get the % in the bottom left chart as I am only allowed to "Show value as  Percent of grand total" and not "column total" in the clustered chart.

My table below - No. of seats and No. of people observed both appear the same number of times (can be thousand over times), while the value/count can be repeated.
Meeting Room Category | Value/Count
No. of Seats                     | 1
No. of Seats                     | 2
No. of Seats                     | 10
No. of Seats                     | 8
No. of Seats                     | 1
No. of people observed  | 2
No. of people observed  | 9
No. of people observed  | 3
No. of people observed  | 1
No. of people observed  | 1

[ryan_mayu]

what's the calculation logic?

e.g. how you get 46%?

[Jacob441]

Values with 0 have been filtered out. But with 0 both totals are 400 and 400.