Hello,
This may be a simple answer but is there a way to create a cross-tab that looks like the following...
# of Accts # of Shirts $ of Revenue
Rep1 10 15 $150.00
Rep2 5 10 $100.00
the # of accounts will have to be a...
hello,
I am trying to rank our sales reps based on total sales in the group header. Right now I got the total sales for each rep in a SUM formula in the group header. Is there a way to sort the SUM of Sales field where the rep with the most sales comes up first.
So for example.
Group Header...
Hello,
I need to pull the second character out of a field. The Field is a string. My field can display the following...
F9CC, F8CC, P8CC, F7CK, F6CC, P7CC, etc. I want to pull the second character (the #) so I can use that for a formula.
What formula should I use to get the second...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.