Matrix Table - Format

[KVS]

Hi Team,

I have done Sum of Value, Varience and Var %, however the below Ttable showing each column wise var and var %, but I need to show last column.

Thanks,

KSV

[nandukrishnavs · Accepted solution]

@KVS  There is a workaround.

Create a new measure

newVAR =
VAR _result = IF ( ISINSCOPE ( Table[Date] ), BLANK (), [VAR] ) RETURN _result

newVAR% =
VAR _result = IF ( ISINSCOPE ( Table[Date] ), BLANK (), [VAR%] ) RETURN _result

Then use these measures in the Matrix. Then reducing the column headers manually and disable column header text word wrap.

Once you get new Year value, you have to reduce the column header width manullay. 

[Anonymous]

If you add year in the column it will split the data based on years