Forum Discussion
cfo
Helper I
Helper INeed help using SWITCH function to add measure to a matrix
Hi - I built a P&L Statement using a matrix from this link. https://youtu.be/W4zEYkDC3Tw. I've found this to be a brilliant solution, but I need to take it an additional step further. I have a mea...
cfoHelper I
Helper IThank you, I think we're almost there, I believe you are saying that I need to break the relationship between my Header table and the table containing the "real values". Once I break the relationship however, it doesn't display the values correctly because it's not connected to my date table. So, that's what I think your code above is helping me with. Are you saying that once I add the code you provided above, that I don't need to use the Switch statement at all, and that Gross Margin% and EBITDA % will appear properly?
cfoHelper I
Helper ICan you also show me how I can get the Gross Margin and EBITDA Margin to appear as % in the matrix? Are you able to attach the sample table with the expected results? Thanks!