Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago

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

  • admin11 , You measure the Annual total causing that to remove. Can you check that calculation.  Not very sure what are trying to do there.