Is it possible to filter a hierarchy with a time intelligence filter?

e.g.

The user would select 'Last 10 Weeks' from the time intelligence filter and it would cascade and show only products who have data in the past 10 weeks?

If yes, how would I connect the two? What is the connection formula like?

Can anyone help me please?

Thank you...

CP

Hi,

To get the last 10 weeks you need a formula like : Week:Week-9

You need to have a date column on you products table.

On the dashboard connect the Time Intelligence Filter to the Grid / Chart by dragging and dropping it. 

for more details have a look at : http://www.bidn.com/blogs/MarkGStacey/bidn-blog/1756/performance-point-relative-date-time-intelligence-with-current-date-time

Hope it helps

cheers

Rgis