How to dispaly measure values for the max Variable (month)?

[former_member227738]

Hi all,

Example from efashion world: Consider the data availablity in the report.

First of all I add an input control on the variable Month. The user can select one or several months together.

I would like to present a summary table by year depending on the choice of the months

BUT!! at the Quantity sold column I would like to show the value for the max/last month and for the sales revenue column to display sum(sales revenue)

The problem of course at quantity sold column. I can not manage to display the value selected for the last month.

Example:

Suppose the user selected months 1 to 4

Quantity sold should be 6,778 and sales revenu should be sum for all 4 months

For a choice of months between 3 and 6 Quantity sold should be 7,057 and sales revenu should be sum for all 4 months

and so on... the Quantity sold column must display the value for the last month that the user choose

Is it possible?

[Former Member · Accepted solution]

Hi,

This is possible.

Follow the steps:

1) Create a variable 

ranking =Rank([Month]) In([Year];[Month])

2) Now use following formula for displaying quantity sold

=[Quantity sold] In([Year];[Month]) Where([ranking]=1)

You will get your desired output.

Thanks,

Swapnil

[former_member227738 · Accepted solution]

Thank You

Great. It solved the problem exactly as needed