100% Stacked bar per dimension

[kennethand]

I like to make a stacked bar (100%). Based on the attatched data (just a sample of a huge data set)I like to create a stacked bare like this. It should be very simple but I cant get it to work myself

[Gysbert_Wassenaar · Accepted solution]

You use two dimensions:

1. Project

2. Q103

And you need one measure:

count(respid)/count( TOTAL <Project> respid)