Highest Sales

[HAmzehAF]

Hello,

i wanna show in a table on my sheet 
- Store -Date -Highest Sales

Highest Sales means i wanna see the max sales i have in all my data and to show one data in which store+data i have this (Highest Sales) 

can anyone help me with this? 

i want the table to only show one data and its the Highest Sales only 

[HAmzehAF]

@Dataintellinalytics 

hello,

Store	Only(Aggr(Firstsortedvalue(Date(Date, 'DD-MMM-YYYY'), -SALE), Store))	MAx(Aggr(Sum(SALE),Store,Date  ))
Test1	04-Feb-2023	172,555
Test2	04-Feb-2023	150,142
Test3	04-Feb-2023	74,547
Test4	03-Feb-2024	60,630
it should be	:
Store	Date	Max
Test1	9-Mar-24	172,555
Test2	18-Feb-24	150,142
Test3	4-Dec-23	74,547
Test4	3-Feb-24	60,630

here what i get and should i get everything is good i get 1 store the right highest sales but im getting the wrong date for this data. 

[Dataintellinalytics]

For Test 1 why 9-Mar-24 why not 04-Feb-2023 ?  Please share the raw data (Store, Date and Sales) for Test1 to understand better.

[HAmzehAF]

@Dataintellinalytics 
Hello,

i cant share the raw data, 
but this sample is like it, 

when i use only(aggr(
i should get  9-Mar-24 date for the highest sales + i get the max sales for the wrong date 
like in test1 -  172,555 max sum(sales) should be in this date 9-Mar-24  not this date 04-Feb-2023 and this date should have 130,453

Store	Only(Aggr(Firstsortedvalue(Date(Date, 'DD-MMM-YYYY'), -SALE), Store))	MAx(Aggr(Sum(SALE),Store,Date  ))
Test1	04-Feb-2023	172,555
Test2	04-Feb-2023	150,142
Test3	04-Feb-2023	74,547
Test4	03-Feb-2024	60,630

the dates here are only wrong but the store name + sales all correct 
- how i know cuz u checked from the database for the highest and i got lets say for test 1 
"

Test1

9-Mar-24

172,555

[Dataintellinalytics]

HI,

You are still sharing the output data, am looking for Raw Input data ( can be mocked need not be original) with Store, Date and Sales information at least for one Store.

Looking for few data for Test1 with multiple dates and sales.