Max value from row

[Ssa90]

Hi!

I have a pivot table:

Product on rows

Date on columns

Measure - sales

         01/01   02/01  03/01

A       10          7           3

B        1          4            4

C        3          11         9

I want to calculate the maximum value for each row and display it in each column

For product A  - 10

B - 4

C - 11

I want this result:

01/01   02/01  03/01

A       10          10           10

B        4         4            4

C        11         11         11

Tell me how to write such a formula?

I understand how to sum by line(sum(total <product> sales)), but I don't understand how to get the maximum...

[Ssa90 · Accepted solution]

Solution:)

MAX(TOTAL <product> AGGR(SUM(SALES), DATE, PRODUCT))

[brunobertels]

hi 

may be 

only(max(aggr(Sum(Sales),Date))