simple set analysis

[#1]

Hello,

A simple setanalysis questions:

If i want to see some data on a dimension but disregarding other dimensions how do i write that then?

Example:

DimensionsEmployee:

ID

Name

DimensionDate:

IDDate,

Year,

Month

Fact:

IDDate,

ID,

Amount

How do i then see amount on my selected employees, but they dont change when selecting year and month?

[#2]

in this case my amount should not be affected by year and month

[bbi_mba_76]

Hi,

try sum({<Year=, Month=>} Amount)

[israrkhan]

Hi,

add Name your Dimension and Sum({$<Year=, Month=>}Amount) your expression.

[#5]

what happens if i put 1 infront

[bbi_mba_76]

With Sum({1<... you ignore all the selections on all the fields.

[#7]

so bascially this will show me all?

[bbi_mba_76]

Yes, if you use sum({1} Amount) all the selections (not only on Year and Month) will be ignored