Bar Chart

[mario-sarkis]

hey all

i have a Bar Chart with its dimenssion a YearMonth i need to show only the last six month how can i do it in Bar Chart ?

hope you can help thank you,

[SatyaPaleti]

Hi Mario,

go to Chart Properties --> Sort --> Keep --> Dimension(YearMonth ) in Descending order and again go  to Dimenion Limits in Propeties --> there is a option called (Restrict which valuees are displayed)  check it that box and below to that you can find a option called (show only) just drop down it and select option from that

Hope it will works

Thank you,

Satya paleti

[Anonymous]

check this link and adjust the set analysis based on your requirement

Relative Calendar Fields

[MK_QSL]

Sample

Create Bar Chart

Dimension

InvoiceMonth

Expression

SUM({<

  InvoiceMonth = , InvoiceMonthYear =, InvoiceQuarter = , InvoiceYear = ,

  InvoiceDate = {">=$(=MonthStart(Max(InvoiceDate),-5))<=$(=Max(InvoiceDate))"}

  >}

  Sales)

[vardhancse]

Chart Properties->Dimensional Limits->Show only