Can you please show the desired output in a tabular form?
Its really hard to imagine what you need. I tried to create dummy data. Refer attached xlsx file.
Also have attached a packaged workbook created in version 10.0.0.
Please let me know if this what you need.
(Its a good practice to mark the answer correct if your question is answered. This helps boarders to work on unsolved questions)
Thank you for the advice. I think the last reply is still missing what I am asking though. See attached packaged workbook using the superstore data....I think I am making this more difficult than it is.
On the attached, I am looking for a distinct count of manufacturers by quarter, that have sales (by quarter) of over $500. I think the attached is correct, could someone just confirm this?
filteringbyquarter.twbx 1.5 MB