Set Analysis Query.

[#1]

How to total only the maximum Amount puchased based on the Customer or Serial Number. Please see the attached SpreadSheet.

[PrashantSangle]

Hi,

What is your expected output w.r.t provided data??

Regards,

[jonathandienst · Accepted solution]

Hi

Use a chart with the relevant dimension (Customer Name or Serial Number) and the expression;

     Sum(Aggr(Max(Amount), [Customer Name]))

     or

     Sum(Aggr(Max(Amount), [Serial Number]))

HTH

Jonathan

[vishsaggi]

Hi Murali,

To what I understood please let me know if below would suffice your query.

To get the max purchased amount use the Max function in the expression with Customer Name or Serial Number as dimension using Straight table chart.

Dimension: Customer Name

Expression: max(Amount)

Please let me know if this is what you requirement is: [Image attached]. It displays the max total amount as you have highlighted in your Excel.

[robert_mika]

This will work as well:

In Textbox:

=     Sum(Aggr(Max(Amount), [Sales Order]))

[vishsaggi]

As the experts mentioned above you can use

sum(aggr(max(Amount), [Customer Name]))

Check the image attached. To get this

1. Go to Char Properties --> Expression Tab --> Total Mode --> Select the Radio button <Expression Total>

2. Go to Presention Tab --> Total option --> Check radio button <Totals on Last Row>

Thanks,
Vish.