max value of a specific type

[beck_bakytbek]

Hi Folks,

my Table does look like

MonthNum	Version	Sum(Sales)
1	Actual	5
2	Actual	10
3	Budget	15
4	Budget	20

my expected output is : i only want to show: the second value of Version: Actual and Sum: 10

i am using this expression: Sum ({<Version = {"Actual"}, MonthNum={"$(=Max(MonthNum))"}>}Sales) and want to ignore the selection (Frontend) in Field: Version. But this expression doesnt work.

Does anybody have any idea how to resolve this issue?

Thanks a lot in advance

[ogster1974]

Sum ({<Version = {'Actual'}, MonthNum={"$(=Max(MonthNum))"}>}Sales)

[beck_bakytbek]

@ogster1974  Thanks a lot for your responce, i will implement it and will let know when i achieve the expected output. Thanks a lot for your help and time