Forum Discussion

mbudiman's avatar
mbudiman
Icon for Helper III rankHelper III
1 year ago
Solved

Hide Measure column in Matrix that contains no value

hello, I have 2 tables, Fiscal_Qtr table and Sales Forecast table. Fiscal_Qtr table contains custom financial quarter period, where a field called Qtr_Sequence_No is used to define sequence of Quart...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    You forgot to either expand or go into the next level in the hierarchy. If there isn't a single field of the display column parameter, SELECTEDVALUE returns blank so none in the switch conditions is met. 

     

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

You forgot to either expand or go into the next level in the hierarchy. If there isn't a single field of the display column parameter, SELECTEDVALUE returns blank so none in the switch conditions is met. 

 

mbudiman's avatar
mbudiman
Icon for Helper III rankHelper III
1 year ago

Got it. Thank you 🙂