3 Replies Latest reply on Jan 26, 2017 9:50 PM by vignes joseph

    Navigate to a worksheet based on measure names selection

    Sridhar M

      Hi Viz Experts,

       

       

      I have a requirement and would need some assistance in achieving the same. I have five measures split by category; I need to navigate(link) a different worksheet based on the measure user selects.

       

       

      Example:

                            Apr      May      June

      Sales             200     400       600

      Profit             100      200       300

      Order Qty       20       100      150

       

       

      So if user select lets says "Sales" it should lead to a different worksheet which has sales details for the selected period, like wise if use selects "Profit" it should navigate/link to a different worksheet which has profit details for the selected period. Each worksheet (Sales details/Profit details/Order Qty Details has different criteria to list the numbers of columns and so building a generic report for navigation is not possible, the goal is to navigate to different worksheets based on user measure selection.

       

      Thanks!!