<p>Hi All,</p>
<p> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">I want to design crosstab report with <span style="color:rgb(0,0,205);"><u>two <em><strong>Dropdowns - Single Select Lists</strong></em> being displayed on the report viewer page</u></span> for the user to make selections.</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dropdown1 item is <em>MIS Period</em> and has 3 values i.e. Year, Quarter and Month.</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dropdown2 item is <em>General Dimension</em> and has 50+ values: Gender, Country, Age, City, Bank etc etc.</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">The report runs on some default dimension and shows a Crosstab. Now, when I select, Dropdown1 = <strong>Quarter</strong> and Dropdown2 = <strong>Gender</strong>, the crosstab report page should change into:</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dropdown1: Quarter Dropdown2: Gender</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> Gender</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Quarter Male Female Others</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> SUM(Sales)</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Q4 2014 4000 2000 4000</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Q1 2015 1000 1000 2000</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">When, I change the Dropdown1 value to <strong>Year</strong> and Dropdown2 value to <strong>Country</strong>, the crosstab report page should change into the below view:</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Dropdown1: Year Dropdown2: Country</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> Country</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Year USA India</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> SUM(Sales)</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">2014 4000 6000</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">2015 3000 1000</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">So, basically, I am trying to build a crosstab in which the Row and Column dimension will change based on the parameter selection. The measure will remain the same.</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">How can I possibly achieve such a report?</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Best Regards</p>
