6 Replies Latest reply on Feb 6, 2019 2:26 PM by Prashantha Madhurashri

    User Measure Names as Action Filter

    Prashantha Madhurashri

      Hello Everyone!

       

      I'm trying to use Measure Names in summary page as a filter in detail page but so far I haven't found a way to do this.

       

      Requirement

       

      I have a worksheet AP count with 3 measures

       

      Underlying table structure

       

      BU        Current Unapproved Invoices        Past Due Invoices                Invoices Recorded but not received

      777                       150                                             50                                               200

       

       

      Summary Worksheet

       

      Each metric and amount

                                                                        Amount

      Current Unapproved Invoices                    $150 

      Past Due Invoices                                       $50

      Invoices Recorded but not received           $200

       

      Note that these are actual column names displayed here (Current Unapproved Invoices etc.)

       

      I am trying to create a detail page to show the detail data for each metric

       

      The detail table data structure is little different and it has a Metric Name column

       

      Metric Name                                          Voucher ID                    Amount

      -----------------                                                                          

       

      Invoices Recorded but not received          123                              200

      Past Due Invoices                                      234                              20

      Past Due Invoices                                      235                              20

      Past Due Invoices                                      236                              10

       

      when a user clicks on Past Due Invoices (Or any other metrics) in Summary page it should drill down to detail page and pass the measure name to detail page and filter Metric Name column in detail page

       

      Detail page

       

      Past Due Invoices                                      234                              20

      Past Due Invoices                                      235                              20

      Past Due Invoices                                      236                              10

      ----------------------------------------------------------------------------------

                                                                          3                                $50

       

      Any thoughts?

       

      Thanks,

      Prashantha