0

Union of custom columns (Static Values)

I am in need of creating a static dimension with multiple measure names such as: sales, expenses, cost, count, etc. These are to be given to a multiselect dropdown in a report that gives the measure names in multiple rows as per selection. I have tried creating a list of custom columns using the Union and facing the error

"Lists must use members from the same table and column"

Is there any possibility of executing this?

Thanks in advance

Ananth
 

4 replies

null
    • Lead Consultant Advanced Analytics
    • Michael_Daun
    • 2 days ago
    • Reported - view

    Hi Ananth,
    this sounds as if you are looking for a Parameters! This is an option when opening Formulate...

    At Step 1 select "Global" (i.e. the values do not come from your model! I think you only need the names of measures, not the measures itself!), at Step 2 select "Text" as List Type and create your list by simply adding caption-value-pairs.

    Finally, Step 3, select the type of slicer/filter which should visualize your parameters.

    When adding this parameter to your chart the user can select a measure name from the drop down. Subsequently, the corresponding measure is assigned to a "dynamic measure placeholder" - technically a formula - which finally delivers the values of the selecred measure. 

    I hope that was your requirement at all! Have a look at this article which describes the interplay between a parameter and dynamic measures or dynamic dimensions: https://community.pyramidanalytics.com/t/p8y69k0/tip-of-the-day-dynamic-dimensions-and-measures

     

    Best regards,
    Michael

      • Ananth_Periyasamy
      • yesterday
      • Reported - view

       Thank you for your response.

      I however wanted to try a multiselect measure by creating a dimension and converting to list as it provided data driven multiselect option.

       

      Regards,

      Ananth

    • VP Product Management
    • Ian_Macdonald
    • yesterday
    • Reported - view

    Hi 

    Are you requiring the selection of groups of measures with a single click?

    For example with one click put all the outgoing Measures ,Expense, cost, Overhead, on the rows, or with another click, Sales, Margin and Net Margin and Units sold on the rows?

    Ian

      • Ananth_Periyasamy
      • yesterday
      • Reported - view

      Hi  ,

      I needed multi select on measure in a dropdown that needs to be append in the rows. For example, if I select the Sales, Expense, Cost from multi select dropdown the report shows as 3 rows with each measures named with corresponding selection. 

      Expected Output:

      Measures A B C
      Sales x x x
      Expense x x x
      Cost x x x

      Example for Multi Select dropdown:

       

      Regards,

      Ananth

Login to reply

Content aside

  • yesterdayLast active
  • 4Replies
  • 25Views
  • 3 Following