Hello,
I have what seems to be a simple problem, and I'm sure it is, but I'm going about solving it wrong.
I have dates and values (which are cumulative) and I need to display the first month only in which a minimum value is reached.
I've gotten to a point where I can show the first date, but all the other dates after that date display as well. So even hiding the header isn't optimal because then the worksheet is too wide.
I've attached the sample workbook. Thanks for any help!
Tanya
4 answers
Tanya,
You can use lod to create a calculated field like this.
[Date] = {FIXED : MIN(if [Value] >=1300 then Date else null end)}
Drag this on the filter shelf and keep the True value.
see in the attached
Michel
