Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you provide the sample, replica of your original application?
Looks Like Concatenate Issue over model
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.