Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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);
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
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)
In Set analysis,
=sum({<[T-Year]={$(=GetFieldSelections(Year))},[T-QTR]={$(=GetFieldSelections(Quarter))}>}Target)
Hi Anbu
it seems working
thanks
gidon