Two Totals in Matrix Table

[Umadhandapani]

Hi, in the image it states two different values, the green color against sales and pink against profit.

Based on the till month selected it will show the sales value, remaining profit.

Here, I required two different totals to be display stating sales and profit seperately.

[v-yetao1-msft]

Hi @Umadhandapani 

Your needs are not very clear, can you provide the original data(without private information) ? When you choose other month , what should be the total ?

Best Regard

Community Support Team _ Ailsa Tao

[Umadhandapani]

Actually, along with total required sales total and profit total.(with three total column)

[Umadhandapani]

Hi, whether two totals can be created dynamically.

[amitchandak]

@Umadhandapani , As I commented on yesterdays post, this might require an independent table , or you can use slicer date table/column, in place of date1/date1[date]

Create a color measure and use that in conditional formatting using field value option

Color measure =
var _max = maxx(allselected(Date1),Date1[Date]) // slicer is on an independent date table

// OR you can use your slicer date column

return
if( max('Date'[Date]) <=_max) ,"Green", "Red")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Umadhandapani]

Hi , required two different total to be display with one showing sum of sales and another sum of profit based on the slicer selection.