Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I need a simple thing to have, let's say I have two dimensions as Branch and Product and expression as Sales like shown below: I am looking for last column calculation.
(Branch) (Product) (Sales) (Aggr Total Branch Sales in each row) << this is required.
AAA AIR 5000 7000
AAA HOTEL 1500 7000
AAA CAR 500 7000
BBB AIR 3000 3400
BBB RAIL 400 3400
CCC HOTEL 1000 1500
CCC MISC 500 1500
Try this
Sum(TOTAL <BRANCH> Sales)
or
Aggr(NODISTINCT Sum(Sales), BRANCH)
Try this
Sum(TOTAL <BRANCH> Sales)
or
Aggr(NODISTINCT Sum(Sales), BRANCH)
Thank you Sunny, perfect. 🙂
Who knew it would be as simple as adding the NonDistinct clause!