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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives