Hi
I have 3 fields; 'Year', 'Product' and 'Price'
I want to be able to show a results table with 'years' across the top, 'product' as a column and 'price' as the data that's relevant to each year and product.
I also want to be able to multi-select the 'Year' field in the search page, so that only the User's selection of years is displayed.
I know I can do this with a Pivot Table, but this option isn't included in my subscription package. Is there a way that any of the other reports can be used to show this?
Thanks for any help!