matrix issue

[Anonymous]

					real result
	januar	februar	march			januar	februar	march
code	1	2	3		code	1	1	1

basicaly i need to count homeany time happen a code in a month

in this exa,ple i say is happen 1 time month

so i should have as result like in inthe right 

for every month all 1

but instead i got result as left

it s make the sum of every month progressive,

how i cna display just the count for a single month

?

[v-piga-msft]

Hi @Anonymous,

From your information, it seems that the result in right is your desired and the result in left is your current result?

If it is, could you share your data sample so that I can help you create the correct matrix?

Best Regards,

Cherry

[Anonymous]

From your information, it seems that the result in right is your desired and the result in left is your current result?

YES

@v-piga-msft

right i cant paste and example can you try to use the one i posted?

[v-piga-msft]

Hi @Anonymous,

From my understand, you posted is your result output not the data sample?

You just share your dummy data  sample which could reproduce your scenario then I could copy and test on it.

Best  Regards,

Cherry