fixed number of dimensions in graph

[#1]

I have a graph with "weeks" as dimensions across the bottom and a simple count as the expression.

I would like the graph to only show the most recent 13 complete weeks - my data goes over a 2 year period

can anyone help?

[tresesco]

Two ways:

• Dimension Limit
• Set Analysis

[MK_QSL]

You can achieve by

1) Dimension Limit (Straight Table not in Pivot Table)

2) Calculated Dimension

3) Set Analysis...

[#4]

Easiest thing would be to use Dimension Limits