set analisys help

[gidon500]

Hi guy

Enclosed is a data file

and qvw file

it includes sales and targets for sales agent

i need to show the target for  the agent , with year and quarter  are selected

(according to the selection of the data 

year and quarter of sales )

i tried  several set analisys formulas  with sucsses

hope you can help

thanks

gidon

[anbu1984]

Problem is association didn't happen on Quarter and Year. Try this

TARGET:

LOAD Agent,

     [T-QTR] As Quarter,

     [T-Year] As Year,

     Target

FROM

(ooxml, embedded labels, table is data);

[gidon500]

Hi Anbu

Since I have more data and dimentions to add

I cannot use this statment

can you help by using set analisys in the object

gidon

[maxgro · Accepted solution]

maybe thie

sum({$ <[T-Year]=P(Year),[T-QTR]=P(Quarter)>} Target)

but I think you should change your db model (example 1 fact table and 1 calendar)

[anbu1984]

In Set analysis,

=sum({<[T-Year]={$(=GetFieldSelections(Year))},[T-QTR]={$(=GetFieldSelections(Quarter))}>}Target)

[gidon500]

Hi Anbu

it seems working

thanks

gidon