ignore calculated dimension

[gauthamchilled]

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

[settu_periasamy]

Can you provide the sample, replica of your original application?

[Anil_Babu_Samineni]

Looks Like Concatenate Issue over model

[rubenmarin]

Hi Gautham, not sure but seems that first column is related with the calculated dimension, the second is not.

Maybe adding a set analysis to the 2nd expression to ignore [Submission Date] and setting the calculated dimension to supress null values.

If ignoring dimension doesn't works you can try adding a "TOTAL <Country, Customer>" clause to the 2nd expression.