Get Min/Max of a expression

[diegodelacruz]

Hello people,

I hope you can help me with a solution. I've been working over a week without a success result.

I am trying to show a pivot table with three dimensions and three expressions.

Dim: Country, City, Brand.

Exp: Total Sale, Minimum Sale, Maximun Sale.

I need to get a pivot table just like this

So far, I've got the max/min value in one cell of each group, but I need those values in all group cells.

[Vegar]

I see two ways to solve this by epressions. Either by an aggr(nondistinct min()) or a min(total <>) .

Screenshot and script is from the attached qvw file. 

LOAD * inline [
Country, City, Brand, Sales
Norway, Trondheim, B1, 558
Norway, Trondheim, B2, 117
Sweden, Vimmerby, B1, 790
Sweden, Stockholm, B1, 747
Sweden, Stockholm, B2, 601
Sweden, Stockholm, B3, 554
];

[Lisa_P]

The pivot table should do this easily.

Country, City and Brand as dimensions

Sum(Sale), Min(Sale), Max(Sale) as expressions

Expand Country and City columns

[Brett_Bleess]

If Vegar or Lisa's posts helped you with things, please be sure to return to the thread and use the Accept as Solution button on the post(s) that got you what you needed, this closes out the thread, gives the posters credit for the help and lets other Members know what worked, so please be sure you complete this step on your posts rather than leaving them open...  If you are still working on things, please leave an update for us on what you still need help solving.

Regards,
Brett