Monthly value % calculation

[#1]

Hi All,

I have a requirement as follows

the dimension is Month and Company.

i need to find the market share for each company in manufacturing market.

so i have kept the dimension as both MonthYear and company.and it is a line chart which shows individual lines for company.

now the Expression should be in such way that it should take

current month value for each company

/

Current month value for all companies

Now the issue is when i using this exp

sum({<Type={'Current'},AREA={'MANUFACTURE'}>}SALES)

/

sum({<Type={'Current'},AREA={'MANUFACTURE'},COMPANY=>}total SALES)

Then the numerator will give the output fr each month where as in denominator it will take for whole year.But it should not be the case.

But when i select a Month then i will get correct output..

But more than one Month is selected then again the result will be wrong.

Can anyone help me with this?

Thanks in advance.

Regards,

Reena

[Anonymous]

any sample data?

[Chanty4u]

did u tried wit ALL

sum({<Type={'Current'},AREA={'MANUFACTURE'}>}SALES)

/

sum({<Type={'Current'},AREA={'MANUFACTURE'},COMPANY=>}AllSALES)

[PrashantSangle · Accepted solution]

Hi,

add <MonthYearField> after TOTAL keyword

like

sum({<Type={'Current'},AREA={'MANUFACTURE'}>}SALES)

/

sum({<Type={'Current'},AREA={'MANUFACTURE'},COMPANY=>}total<MonthYear> SALES)

regards

[#5]

when i am using ALL it will take the entire sales irrespective of Moth and year

[#6]

Thanks a lot ..

It worked.

new Learning..

[Chanty4u]

Hmmm ....

if u got the solution.please close the thread by making correct and helpful answers.

Thanks

Suresh chanty

[#8]

Done..Already..