Sum on one dimension where many

[alanmcgrath]

Hi Everyone,

I am replicating and enhancing a report in QV that was previously done in Excel but getting stuck where there was a SumIF in excel, I can't seem to replicate that portion.

I have a straight table in QV that has several dimensions and would like to add an expression that sums only on one dimension but can't seem to figure out how.

Attached is a spreadsheet with some dummy data and column  "Cost by Client Type" is what I'm trying to get to.  I'm sure its easy but I can't figure it out.

Thanks!

Client Type	Client Name	Order	Order Name	Manager	Cost	Cost by Client Type
1	ABC	123	April1	Bob	100	450
1	DEF	124	April1	Jim	200	450
1	GHI	125	March1	Bob	150	450
2	ABC	126	Feb1	Mark	100	400
2	ABC	127	Mar1	Dave	300	400

[#2]

Try this:

SUM(TOTAL <[Client Type]> Cost)

Thanks,

Clark