April 25, 2017 at 2:49 am
Hi guys
I have three measures (Cr Accrual, Quantity, Stk Amount) that are all summed up per year, for example:
Cr Accrual Quantity Stk Amount
| -4,647 | -506 | -4,647 |
| -265 | -1 | -265 |
| -152,383 | -1 | -152,383 |
| -1,732 | -1 | -1,732 |
| -34,572 | -1 | -34,572 |
| -8,503 | -1 | -8,503 |
--------------------------------------------------------
TOTAL TOTAL TOTAL (these are genuine totals and not the word "TOTAL")
---------------------------------------------------------
Problem is, I have an order number that I want to count, as in how many order numbers per year, for example:
Order Number Cr Accrual Quantity Stk Amount
| 677558 | -4,647 | -506 | -4,647 |
| 677782 | -265 | -1 | -265 |
| 677929 | -152,383 | -1 | -152,383 |
| 687253 | -1,732 | -1 | -1,732 |
| 688182 | -34,572 | -1 | -34,572 |
| 688183 | -8,503 | -1 | -8,503 |
----------------------------------------------------------------------------------
TOTAL TOTAL TOTAL TOTAL
----------------------------------------------------------------------------------As you can see there are 6 Order Numbers. I have pulled the order number column into the measures dimension order to do a count distinct, but the problem I have it now creates a different measure column, while I want to count the already existing order number and display it underneath the Order Number as above (at the moment it is blank)
Any help would be greatly appreciated.
Kind regards
Fred
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply