cancel
Showing results for
Did you mean:
Not applicable

## Set analysis

Hi all please find the below questions and give me explanation

1) I have multiple years like 2000 to 2016. If I select year 2005 I want to display the sales from 2000 to 2005 sales.

2)If I open the document I want to display the year wise quarter wise sales how can u do?

5 Replies

First one you may write this

1) Sum({<Year = {"\$(<= Max(Year))"}>}Sales)

Second one can you describe more. Year wise and Quarter wise means

2) Sum({<Year=, Quarter=>}Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator III

Hi amar,

Try This,

For First one:-

1) sum({<yearfield={"<=\$(=max(yearfield))"}>}Sales)

For second one you have to create triggers in document properties(ctrl+alt+D)--> Onopen..

There you can create whatever you want to display.

Not applicable
Author

Hi Amar,

Can you explain your requirement more elaborately,

Which Chart you want to use ? Bar chart or something else.

In Query 1 : You want to show year wise sales for the selected and earlier years ?

In Query 2 : You want to show year wise as well as quarter wise (Two dimensions) for current year only by default or what when you open the document ?

Master

Hi,

Check this

```Sum({<Year = {">=\$(= Max(Year)-5)<=\$(= Max(Year))"}>}Sales)
```

For last 5 years based on your'e selection.

As, your'e second query tells like year and quarter,But what you want to pick i.e which year and which quarter when opening document.Can you please elaborate more.

HTH,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Creator III

hi

You can try with

Sum({<Year = {"\$(>=Min({1}Year)<= Max(Year))"}>}Sales)

Regards,

Rohit

Community Browser