value is doubled as soon as i use a matrix instead of a table

[Anonymous]

hi

have this example of a Customer nr, Year, month nr and revenue and it looks like this:

99999 2022 1 100

99999 2023 1 150

Using a table will present the proper data but if i switch to a Matrix (customer -row, year - column, revenue- value) the revenue is doubled and i cannot change the setting from sum to do not summarize. 

The data format of the revenue is decimal 36,2

How can i change this???

thnx

M

[Anonymous]

hi Xiaoxin,

thanks for the swift response, appreciate it but we found a workaround to bypass this issue and it works.

Again, thanks for your support.

[Anonymous]

HI @Anonymous,

I'm glad to here you find the workaround by yourself.🙂 Did you mind to share the solution here? I think they will help other users who faced the similar issues.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng