Hello! Pls. help me solve my problem...I've been stuck with this issue for days... I have a chart table that some values in my total value (under Expressions tab) got duplicated while some were ok... My formula is just simple
({<Source={'Category}>}TotalValue) ....If i put the total value field in the dimensions, computaions seems ok ... But it doesn't allow me to take out the expressions 'coz it will give me 0 records.. Not sure if it has something to do with the synthetic table which I have trouble i fixing it... I also tried switching to pivot table to no avail.
Pls. help.
Tks.
