Grouping data

[Frankie_Vannini]

Hi there

possibly it is  a silly question however I was not able to find a solution (my fault for sure...)

Assuming I have a table with several columns, looking at the example below how can I dinamically grouping data with a result that is grouped by Level, then shows the member and just the cheapest price? in essence the result should display just 3 rows:

High, Dark Blue, 19.3

Medium, Black, 16.1

Low, Blue, 9.8

The purpose is to build  a tooltip report page based on on this logic that shows the result dinamically once the mouse is passed on the chart where the tooltip is linked

Thanks in advance

F

Level	Member	Model	Price	Other fields…
High	Red	alfa	21,4
High	Violet	beta	20,1
Medium	Black	gamma	16,1
High	White	mickey	22,2
Low	Blue	omega	9,8
Low	Brown	ice cream	15,4
Medium	Pink	pizza	17,2
High	Dark Blue	water	19,3
Low	Green	wine	11,3

[Greg_Deckler]

One way you could do this is to create a filtering measure like:

__Show = 
VAR __table = SUMMARIZE(ALL(Table5),[Level],"__Min",MIN([Price]))
VAR __level = MAX([Level])
VAR __price = MAX([Price])
RETURN
IF(__price = MAXX(FILTER(__table,[Level] = __level),[__Min]),1,0)

Then just filter out your 0's.

[Frankie_Vannini]

Hi @Greg_Deckler 

thanks you for your answer

your solutions works perfectly on the report page, where I've the table, so only the cheapest price is displayed for each level however it doesn't work when I use that page as tooltip report page

in essence when I move the mouse over the chart linked to that report page as a tooltip, the window is empty, no data displayed. 

I've seen this method takes a while on calculating the result on the report page (almost 40M records to check) so possibly it is difficult to manage the result as fast as it should be moving the mouse over the charts data

Thanks

Krgds

F