Forum Discussion
Issue in the filter
Hi Satish_Kumar，
>> if Doc.No Xxxxx having multiple Payment, the result should show the value =15000 gainst the Doc No Xxxxx.
10000 1st
2000 2nd
3000 3rd
I create the sample data and create a new table using the formula.Table 2 = SUMMARIZE(Table2,Table2[Type],"Amount",SUM(Table2[Doc]))
As shown in the snapshot, it will return the desired result about sum of “Doc” group by “Type”.
Based on my understanding, do you want to calculate the sum of amount for “Entry Type”=1 group by Document No_, Posting Date, Entry Type, right? If it is, I try to reproduce it using your given sample data.Create a new table using the formula below, and get expected result shown the screenshot.
Table = SUMMARIZE(Table1,Table1[Document No_],Table1[Posting Date],Table1[Entry Type],"Invc Amount",CALCULATE(SUM(Table1[Amount]),Table1[Entry Type]=1))
If you have any other issue, please share more details.Best Regards,
Angelia
Cool dude,
First u could under stand the logic what u did .
based on your Summarize function it is correct result .
see the condtion u have applied in new column level then how it will work at table level ?
make sense.
if u want only Entry type =1
add filter in front of Summarize and apply filter where entry type = 1
example :
Filter ( Summarize(............), Entry_Type =1 )
it will help u, let me know if any help.
I have did that Baskar but at the end the summerize donot giving the correct value.
For Example-
if Doc.No Xxxxx having multiple Payment
10000 1st
2000 2nd
3000 3rd
the result should show the value =15000 gainst the Doc No Xxxxx
But its is not giving the correct it only shows the value i.e. 10000
Do one thing my friend share some sample data and what is ur expected result .
i will help u