How to make my Table 1 LYTD amount appear ?

[admin11]

Hi All

Hope some one can advise me how to make LYTD amount appear on Table 1.

it can display LYTD amount on Table 2.

My PBI file :-

https://www.dropbox.com/s/jpa0y0i7xzqohjb/SAMPLE_1000_SI_TI_V027.pbix?dl=0

Paul

[V-lianl-msft · Accepted solution]

Hi @admin11 ,

Create relationship in BRAND_C column.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@V-lianl-msft 

Thank you very much for your help , it work .

I notice that your screen shot on Table it does have Total amount , but mine table does not display total amount.