Forum Discussion
Post PartisanHow to combine to matrix visuals
You will need to disable the total row and a custom total row to the column you're using. Total will always be on the bottom or top depending on the visual. You can conditionally format the text color or the background to highlight the total.
total background = IF ( tbl[tradetype2] = "Total", "#eeeeee" ) --to be used as field valueYou will also need to use dynamic format strings to apply a different for mat to %. Example:
IF ( tbl[tradetype2] = "%", "0%", "0,0" )
Post PartisanHi Ritaf1983 ,
Thank you for your response.
I followed one of the blogs you sent and it got me this far:
But the issue is I don't see tTO flowing into my matrix visual though I have declared a variable called tTo (which should display the total).
I have also included this in my HeaderTable as below:
But for some reason it does not show in my visual matrix. It does show when i remove the columns and values from my matrix as per below:
