Build the Bar graph to see the total sales for all the category only for last two Years

[Anonymous]

I am having the Fact Table Like Below format ,

Order ID
Order date

Mobile phone (Cost of Mobile)

Laptop (Cost of Laptop)

TV(cost of TV)

Monitor (Cost of Monitor)

Build the Bar graph to see the total sales for all the category( Mobile phone,Laptop,TV,Monitor)only for last two Years from the current date

using order date i have created the Year

and Using Set Analysis i have capture the last 2 years, but i dont have idea how to display for all the 4 dimentions(Mobile Phone, Laptop,TV,Monitor)

[Anonymous]

using order date i have created the Year

and Using Set Analysis i have capture the last 2 years, but i dont have idea how to display for all the 4 dimentions(Mobile Phone, Laptop,TV,Monitor)

[Anonymous · Accepted solution]

by using crosstable i am able to achive it