Problem with Duplicates

Question

I have a list of clients, that duplicates in same month.

My target is for each month separate the accumulated values by client and positive vs negative, in matrix table

For example: Month 1 Positive = 650 Negative = 0

Month 2 Positive = 650 Negative = -400

........

Help me please?

ashish_mathur · Answer

Hi,&nbsp;There is no need to create a calculated column formula of "Accumulaed values".&nbsp; In the visual, drag Month and write the following measures:&nbsp;Positives=SUM(Data[Positive])Negatives=SUM(Data[Negative])Accumulated values=[Positives]+[Negatives]&nbsp;Hope this helps.

ruinaldo · Answer

Thanks for your help. But i need in diferent columns the result in month 2 positive =650 and negative = -400

ashish_mathur · Answer

Sorry but i do not understand.&nbsp; Show your data and your expected result.&nbsp; Where is suggested&nbsp;formula giving you the incorrect result?

ruinaldo · Answer

Hi,I have a table of clients movements by month. I don´t need the sum of positive or negative valuesI need by month the accumulated values by client. And each month i have client balance positive others negative that i want separate in diferent columns.Month 1 = positive (650) = acumulated balance of clients 211000500 (500) and 211000700 (150)Month 2&nbsp; = positive (350) =&nbsp;acumulated balance of clients 211000500 (200) and 211000700 (150).&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; negative = acumulated balance of client 211000600 (-100).............&nbsp;

ashish_mathur · Answer

Hi,&nbsp;Share the link from where i can download your file.

Forum Discussion

Problem with Duplicates

7 Replies

Related content

Duplicate ranking

Logic problem?

remove duplicate value within a row

Removing Duplicates

Slider problems