Overall Percentage for current month in KPI

[kalaino1]

Hii,

I want  to show the comparison of Budget Vs sales in dashboard for current month .

my requirement is show in KPI for Overall budget %, Overall sales % and Overall Budget vs sales % for current month.

Overall means (including all items )

my current Year = 2009

my current month= Apr

help me ..

Thanks in advance...

my data like this..

[rubenmarin]

Hi, if your table in Sense looks like that and BgtAmount is the name of the field storing the value, the expression could be:

Sum(BgtAmount)/Sum(TOTAL <Year, Month> BgtAmount)

Or to make the overall for each customer:

Sum(BgtAmount)/Sum(TOTAL <Year, Month,[Customer Number]> BgtAmount)

[kalaino1]

hii I still cant figure out...

my expression is like , for including all items & my field is Salesvalue.. for current month..

Sum(SalesValue)/Sum(TOTAL <Year, Month, ItemCode> SalesValue)

[rubenmarin]

Hi, and what dimensions do the table has?