Hi I am new to to SSRS...I have requirement to create a report based on filter
I need to select Product>Product type>Product name>Total revenue(fact value) based on the Date.
For more clarity all the information should be in Drop down
select Product Type
select Product Name
and display the total revenue.
All the fields Product,Product type and Product name are in different dimension tables.
How can i achive this from SSRS