Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Column in Matrix

Hello,

 

I have the next Matrix and need that NEW_COLUMN has the same value that HANDLED column when Negocio is online.

The result of the NEW_COLUMNS is OK when I only select one day. For example 25/11/2019 or 28/11/2019

The problem occurs when I select two or more days at the same time 25/11/2019 and 28/11/2019.

For example the value off "La Coruña" (online) is biggest than "La Coruña" (store) because not exists row for "La Coruña" (store) the day 25/11/2019.

 

 

Thanks for help me

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi Anonymous ,

     

    Did you set any filter of the visual? 

    Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.