title: Dynamic Breakdown Dimension with Mixed Data Type (Text and Number)
body: <p>Is it possible to make a dynamic Breakdown Dimension with mixed Data Type?</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1eCxUFNweYcSujp7xbJblxhsg9NEYja6EOgcSKitYJWA/edit?usp=sharing" rel="nofollow noreferrer">This is the data source sample</a></p>
  <p><a href="https://datastudio.google.com/reporting/071875b5-d6e5-4602-bbc1-56ddd791b669" rel="nofollow noreferrer">This is the Report I Tried</a></p>
  <p>Basically I want the user with view only permission to dynamically change Breakdown Dimension for Q1-Qn chart's with C1-Cn Breakdown Dimension</p>
  <p>I tried with the following step:</p>
  <ul>
  <li>Create Parameter <code>breakdown by parameter</code></li>
  <li>Create a Custom Field with this formula:</li>
  </ul>
  <pre><code>CASE breakdown by parameter
    WHEN &quot;C1&quot; THEN C1 
    WHEN &quot;C2&quot; THEN C2
    WHEN &quot;C3&quot; THEN C3
    WHEN &quot;C4&quot; THEN C4
    WHEN &quot;C5&quot; THEN C5
  END
  </code></pre>
  <ul>
  <li>Add Control for the parameter</li>
  <li>Use the custom field in Chart's Breakdown Dimension</li>
  </ul>
  <p>But it says <code>Invalid formula - THEN/ELSE arguments have incompatible types: TEXT/ NUMBER. All THEN/ELSE arguments must return the same type.</code>. Is there a workaround for that ? it's working fine if the breakdown dimension is text only or number only.</p>
  <p>I also use a control to filter the data, so I want to use control to filter C1-Cn columns and to set breakdown dimension to C1-Cn columns</p>