<p>I want to design crosstab report with <span style="color:#0000cd;"><u>two Dropdowns being displayed on the report page</u></span> for the user to make selections.</p>
<p> </p>
<p>Dropdown1 item has values: Year, Quarter, Month</p>
<p>Dropdown2 item has values: Gender, Country</p>
<p> </p>
<p>When I select, Dropdown1 = <strong>Quarter</strong> and Dropdown2 = <strong>Gender</strong>, the crosstab report page should look like following:</p>
<p> </p>
<p>Dropdown1: Quarter Dropdown2: Gender</p>
<p> </p>
<p> Gender</p>
<p>Quarter Male Female Others</p>
<p> SUM(Sales)</p>
<p>Q3 2014 3000 2000 1000</p>
<p>Q4 2014 4000 2000 4000</p>
<p>Q1 2015 1000 1000 2000</p>
<p> </p>
<p>Now, I want to change the Dropdown1 value to <strong>Year</strong> and Dropdown2 value to <strong>Country</strong>. So, when I set Dropdown1 = <b>Year </b>and Dropdown2 = <strong>Country</strong>, the crosstab report page should change into the below view:</p>
<p> </p>
<p>Dropdown1: Year Dropdown2: Country</p>
<p> </p>
<p> Country</p>
<p>Year USA India Srilanka</p>
<p> SUM(Sales)</p>
<p>2014 7000 4000 5000</p>
<p>2015 1000 2000 1000</p>
<p> </p>
<p>The headers should change and the crosstab should display values as per the new dimension selected.</p>
<p> </p>
<p>How can I possibly achieve such a design in OpenText?</p>
<p> </p>
<p>Best Regards</p>
