Forum Discussion

Imrans123's avatar
Imrans123
Advocate V
4 years ago
Solved

Building a Multi KPI Table

Hey All,    Wanted some help from you guys. My data model is such that I have a billings table with sales data and a column called store ID which represents the store the sale is happening at. Just...
Need Help
Show and Tell
  • johncolley's avatar
    johncolley
    4 years ago

    Hi Imrans123 ,

     

    You can try combining the results and target into one measure to use in the matrix. For example:

     

    Combine = COMBINEVALUES(" / ", Sales Measure, Sales Target Measure)

     

    If this answer solves your problem please mark it as a solution!

johncolley's avatar
johncolley
Solution Sage
4 years ago

Hi Imrans123 ,

 

You can try combining the results and target into one measure to use in the matrix. For example:

 

Combine = COMBINEVALUES(" / ", Sales Measure, Sales Target Measure)

 

If this answer solves your problem please mark it as a solution!

  • Imrans123's avatar
    Imrans123
    Advocate V
    4 years ago

    Perfect! Thank you!