urgent help[ required in bar chart

[#1]

Hi All,

I'm having a bar chart X- axis of this chart is date in MMM_YYYY format.

There are more than one entry in single month so chart has to sum up these things and have only one bar for one month. Currently chart is having more than one chart for each month as there are more than one record for each month. But how do i make it to show one bar per month ?

Attached is sample file.

Thnaks

[senpradip007]

Can you upload sample qvw?

[#3]

Hi Pradip,

PFA file.

[kamalqlik]

Hi Kavita,

I am not able to get what you want.

Can you explain it more clearly as per your requirement.

Regards,

Kamal

[#5]

Hi Kamal,

I had uploaded wrong file. Now I have changed it. If u open the file I shared now, You can see multiple bars for Dec-2012. All I want is have single bar for Dec-2012(or have single bar for every month).

[kamalqlik]

Hi Kavita,

Please attach the file to.

[#7]

Hi Kamal,

I have attached the updated file . Please see my previous comments

Kavita

[senpradip007]

Try somthing like:

Aggr(sum( BILLED_AMT1), MONTH_BILLED)

[tresesco]

Remove your group as dimension and take Billed_Month as dimension. PFA

[jagan]

Hi,

Give this as expression in your Drill down Group

=Date(MonthEnd(MONTH_BILLED), 'MMM-YYYY') instead MONTH_BILLED.

or  Create a new field in script like below and use it in Drilldown group

LOAD

*,

Date(MonthEnd(Date#(BILLED_MONTH,'DD-MMM-YY')), 'MMM-YYYY') as BILLED_MONTH

From DataSource;

Hope this helps you.

Regards,

Jagan.