title: How do I achieve this output in a Google Data Studio report, given the raw data?
body: <p>I have a small set of test records in Google Data Studio and am attempting to create a table that gives me breakdowns of particular values relative to the total number of values, by dimension.  I think the image here below describes the need clearly.  I have tried using an approach I saw online entailing creating a calculated field like this:</p>
  <p>case when Action = 'Clicked' then 1 else 0 end</p>
  <p>and then creating a metric based upon that field, which does the 'Percentage of Total - Relative to Corresponding Data' but this produces incorrect numbers and seems really cumbersome (needing one calculated field per distinct value).  My client wants this exact tabular presentation, not a chart(s).</p>
  <p>How do I achieve the desired report?</p>
  <p><a href="https://i.stack.imgur.com/DvtyL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DvtyL.png" alt="Details:" /></a></p>
  <p>Thanks!</p>