I believe it's doable. Let's go!   Here's two pics of what I created:   And here are the steps I took to achieve this.   Step 1: Create New data items Parameter: _par_fiscal_year , type is Character. To this parameter we will store the user selection from Drop-down list. Calculated item: Year (current), Result Type is Date, Format is Year4 (Year). Here we parse the parameter _par_fiscal_year to get the current year the end user wants in his comparison table. We will use Year (current) later on to subset the data to two years that we will induce from Drop-Down list selection. DateFromMDY(1, 1, Parse(Substring('_par_fiscal_year'p, 1, 4), 'COMMA32.')) Calculated item: Year (previous), Result Type is Date, Format is Year4 (Year). Here we parse the parameter _par_fiscal_year to get the previous year the end user wants in his comparison table. We will use Year (previous) alongside Year (current) later on to subset the data to two years that we induce from Drop-Down list selection. DateFromMDY(1, 1, ( Parse(Substring('_par_fiscal_year'p, 1, 4), 'COMMA32.') - 1 )) Calculated item: My Year, Result Type is Date, Format is Year4 (Year). Now we subset the data to two years based on rule "if user selection is 2019-20 then the comparison should be between 2018 and 2019". IF ( ( 'Date (Year)'n = 'Year (current)'n ) OR ( 'Date (Year)'n = 'Year (previous)'n ) ) RETURN 'Date (Year)'n ELSE .   Step 2: Drop-down box Category = finyear, Parameter = _par_fiscal_year, Check in Required from Options pane   Step 3: Crosstab Columns: My Year, Rows: Col A, Measures: Measure Filter:  ( 'My Year'n NotMissing )   Please try this and let me know how it went.   Best regards, Petri ... View more

Hello @harshpatel,   Here's how you can do that.   Step 1: Create a parameter In the Data pane, click New data item, and then select Parameter. The New Parameter window is displayed. Modify the Name of the parameter f.ex. _par_month Select the Type = Date for the parameter. Specify additional information: Minimum value, Maximum value and Current value. Do not get confused about the Year as it doesn't matter. Select a preferred Format = Month. Click OK and your new parameter can be found from the bottom of Data pane. Step 2: Apply parameter role to Drop-down list Select your Drop-Down list and open the Data Roles pane. Assign you just created parameter _par_month to the role Parameter. Step 3: Create a new calculated item In the Data pane, click New data item, and then select Calculated item. The New Calculated Item window is displayed. Enter a Name f.ex. My Salary.  Create formula shown below: IF ( '_par_month'p >= 'Month'n ) RETURN 'Salary'n ELSE 0 Now you can utilize your new measure in the report.   I hope this helps!   Best regards, Petri ... View more

Sure,   This is how my data looks like: Notice that I have one hierarchy defined as: Reference Point -> Customer   The object I use is called Geo network in VA8.5. In VA8.3 you can use Network Analysis object. You get the map to background from Options -> Network Display -> Network Diagram -> Map background = checked.   The only data role you need is to assign the hierarchy you created to Levels. Then I manually created coloring rules for Reference Points: I think that was it. Please ask if you get stuck at any point.   Best regards, Petri ... View more

Hello @Kyle4 ,   Please try the AggregateTable operator that was introduced in VA 8.3. Here is code snippet which you can easily copy-paste to your editor.    Steps: + New data item -> Calculated item Switch the editor from Visual to Text mode Copy paste the code below I assumed your variable names were: Month, Product, and Measure. AggregateTable(_Sum_, Table(_Sum_, Fixed('Product'n, 'Month'n), 'Measure'n)) / AggregateTable(_Sum_, Table(_Sum_, Fixed('Month'n) , 'Measure'n)) And here is how my Crosstab looks like.   I hope this helps 😃   Best regards, Petri ... View more