Hi

I have prepared a kpi dashboard for our customers as per below layout.

A16 - O83 Range Name = PeriodGraphs
J88-O100 Range Name=Data Table by Month
B88-G104 Range Name = Data Table by Routing
A87-O106 Range Name = Volume Data (basically covering the range of both Data Tables)

Slicer Metric: (Volume, Ranking)
Slicer View: (Data, Period Graphs)
Slicer Subview: (Lane, Period)

How it should work.
1. Slicer subview should be invisible and should only become visible if Slicer View=Period Graphs
2. If user click Slicer Metric=Volume and Slicer View=Period Graphs then range A16 O83 should be visible and all other ranges hidden
3. If user clicks Slicer Metric=Volume and Slicer View=Data then
a. Slicer Subview becomes visible
b. If the user clicks Slicer Subview=Lane, then Range B88-G104 becomes visible and all other ranges are hidden
c. If the user clicks Slicer Subview=Period, then Range J88-O100 becomes visible and all other ranges are hidden

Please help with setting this up. Thanks!