Bar chart

[shamitshah]

Hi,

I have created a bar chart (see attached) which shows the budget by month.

I'd like to amend it to show the budget by month for FY2017 and just one bar for the FY2018 ($3965).

Appreciate your assistance.

Thanks

[prma7799]

like this ?

[prma7799]

Some new changes

[passionate]

Hi,

Use Dimension limit for first 13 values.

Rename label for others with 2018.

Regards,

Pankaj

[antoniotiman · Accepted solution]

HI,

see Attachment.

Regards,

Antonio.

[shamitshah]

Hi Pankaj,

Are you able to attach your suggestion?

Thanks

[prma7799]

Please check

[passionate]

I won't be able to attach QVW.

But, steps are easy:

1. Dimension: Month

2. Expression: Sum(Budget)

3.Go to dimension limit tab -> Restrict your data-> First-> 13

4. Keep others check box enabled and put label as 2018.

Regards,

Pankaj

[shamitshah]

Thanks!

[antoniotiman]

Hi Shamit,

Thanks.

I made a slight adjustment regarding Label.

Regards,

Antonio