Forum Discussion
admin11
5 years agoMemorable Member
How to make GL Code 80018 capture at Table 3 ?
Hi All
I am creating a P&L report using PBI.
Table 1 shown raw data have GL Code 80018 Amount 1,736,474.83
Table 2 shown GL code 80018 Capture at Fin Category Table
Total Sales = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Summary]="Sales")*-1
But Table 3 not display GL Code 80018 , only capture GL Code 80020 & 80026
Where go wrong ?
https://www.dropbox.com/s/dggq8vct4bot598/GL_WORKING%20v017%20ask_.pbix?dl=0
above link is my sample file.
Paul Yeo
1 Reply
- amitchandakSuper User
admin11 , You measure the Annual total causing that to remove. Can you check that calculation. Not very sure what are trying to do there.