Dimension/Expression

[#1]

Hello,

I would like to get the result as below. I tried to set up three Dimensions: Submitted_status, Sumitted_year and Submitted_month, and two Expressions: Submission total and % on time. All these should also match when the submitted_company = 'A'.

So I worte the code for "%on time" shows as below,

if ((Submitted_Status) = 'ontime',
((Sum ({$<Submitted_Status = {"time"}, submit_company = {'A'}>} Submission_count))
/(Sum( {$<submit_company = {'A'}>} Submission_Count))),
((Sum ({$<Submitted_Status = {"Submitted late"},submit_company = {'A'}>} Submission_count))
/(Sum( {$<submit_company = {'A'}>} Submission_Count)))
)

However, I cannot make the  "%on time" expression work. Can anyone please let me know or provide me any hints that how to get my expressions with the current dimensions?

Thanks a lot!

Becky

[#2]

Thanks so much Vineeth. Problem sovled!

Best,

Becky

[#3]

Thanks!

[vinieme12]

Glad to help

Cheers

V