Hi,

I have a straight table comparing current year submission amount and another expression previous year submission amount.

I have dimension something like below

Country,

Client,

=Aggr(Only({<Period={"$(=Period)"}>} Submission Date), Submission Date)

problem is after adding the submission date for current year, the previous year submission amount is not populating.

but if i disable calculated dimension highlighted above then the expression is calculating,

how to ignore this calculated dimension or can i use it as expression???

Gautham