How to get vaues corresponding to maximum value?

[#1]

Hi,

I have data as below in qvw. I need the pivot table should show only values which have Maximum FirstNumber. corresponding values to the Maximum FirstNumber

please see attached sample Input data.

I need out put  as shown in attached Output.

Thanks.

[#2]

Thanks. I want the over all Total as sum of all months sales. Individual Total on individual month as well.

is it possible.

please see attached

for eg: there is case B01149 with sales in Aug 2015 and Sept 2015. In Aug 2015 the sales is 160 for maximum FirstNumber 3 and in Sept 2015 the sales is 456 for maximum FirstNumber 3. so, I need the overall Total as 616 and individual month Total as 160 for Aug 2015 and 456 for Sept 2015.

would it be possible.

please can help me as this is very priority report to complete.

[sunny_talwar · Accepted solution]

Have a look and see if this is what you want

Best,

Sunny

[#4]

That's perfect Thanks.

[sunny_talwar]

No problem

Best,

Sunny