Add Dimension in QS

[#1]

Hai Master QS,

I have Question from data bellow

Growth	Sales	Absolute
	600	26
3%	100	3
4%	200	8
5%	300	15

How we add absolute value & summarize in QS without add field in database?

Need adv,

[dominicmander]

Hi,

In this case you can just add a measure with the expression Sum(Sales*Growth).

[#3]

Hi

make a different table and make column  "absolute value" & "summarize" and one "Id" then apply join with main table

Regards

ajai

[#4]

Thanks Dominic.

[dominicmander]

No problem. Glad to be able to help. It might be helpful to mark the answer correct so that this question no longer appears in unanswered questions.

(It would also help me get a few points so that I no longer need to wait for my posts to be moderated each time )