Is it possible to show one row per brand in my report?
Is it possible to show one row per brand in my report? i only want to show here is the what is the latest
Best Answer
-
Hello @Cybsss
A helper column could potentially be useful to you here.
If you were to have a check box column in your sheet with a formula to check the MAX date for each brand, you could use that as a filter criteria in your report.
The formula below asks if the [BRAND (if Applicable)]@row equals [BRAND (if Applicable)]@row AND also has the MAX (newest date) in [PRICE AS OF DATE]@row then show 1, else show 0. (Essentially, check the box with the newest date for each brand)
=IF(AND([BRAND (if Applicable)]@row = [BRAND (if Applicable)]@row, [PRICE AS OF DATE]@row = MAX(COLLECT([PRICE AS OF DATE]:[PRICE AS OF DATE], [BRAND (if Applicable)]:[BRAND (if Applicable)], [BRAND (if Applicable)]@row))), 1, 0)
In your report you can then add in the filter criteria to only show rows where [Helper - Latest Date/Brand] is checked.
I believe this should achieve what you are looking for:-
I hope that is helpful to you in some way,
Protonsponge
Answers
-
Hello @Cybsss
A helper column could potentially be useful to you here.
If you were to have a check box column in your sheet with a formula to check the MAX date for each brand, you could use that as a filter criteria in your report.
The formula below asks if the [BRAND (if Applicable)]@row equals [BRAND (if Applicable)]@row AND also has the MAX (newest date) in [PRICE AS OF DATE]@row then show 1, else show 0. (Essentially, check the box with the newest date for each brand)
=IF(AND([BRAND (if Applicable)]@row = [BRAND (if Applicable)]@row, [PRICE AS OF DATE]@row = MAX(COLLECT([PRICE AS OF DATE]:[PRICE AS OF DATE], [BRAND (if Applicable)]:[BRAND (if Applicable)], [BRAND (if Applicable)]@row))), 1, 0)
In your report you can then add in the filter criteria to only show rows where [Helper - Latest Date/Brand] is checked.
I believe this should achieve what you are looking for:-
I hope that is helpful to you in some way,
Protonsponge
-
Thank you so much! It works! @Protonsponge
