1 of 1 people found this helpful
Paul, since you didn't give us much to go on (sample workbook, or screenshot of your entire screen, or list of calculations you tried that didn't work) this will be a very generic answer:
IF LAST()=0 THEN 'Show' ELSE 'Hide' END.
You can do this using the Last() function. I've attached a workbook and a diagram of the basic concepts:
The note about "data densification" is important in this example because I'm looking to get the Last N values for each category. Since some categories don't have a sale for each date, I wanted to avoid Index() filling in the missing dates and thus missing the fact that the last 10 sales for Furniture started several days prior to the last 10 sales for Office Supplies.
If your case does not include a dimension like Category, you may not need to get this complex.
Last N Items.twbx 1.1 MB
Thanks Josh - This helped alot. I still used Index in my case because the data is not spaced well for timing of entry. For now, index worked for me!
EDIT: Nevermind the index, it was all out of order so your method works the best with the date.