daily pastebin goal
64%
SHARE
TWEET

Untitled

a guest Jan 22nd, 2019 42 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. +----------+-----------+-------+---------+
  2. | Customer | Territory | Date  | Invoice |
  3. +----------+-----------+-------+---------+
  4. | CU1      | A3        | Date1 | I1      |
  5. | CU2      | B2        | Date2 | I2      |
  6. | CU1      | A3        | Date3 | I3      |
  7. +----------+-----------+-------+---------+
  8.    
  9. +-----------+--------+
  10. | Territory | Parent |
  11. +-----------+--------+
  12. | A1        | A1     |
  13. | A2        | A1     |
  14. | A2        | A2     |
  15. | A3        | A1     |
  16. | A3        | A2     |
  17. | A3        | A3     |
  18. +-----------+--------+
  19.    
  20. SP.Territory = View.Territory
  21.    
  22. @TerritoryParam = View.Parent
  23.    
  24. +----------+-----------+-------+---------+
  25. | Customer | Territory | Date  | Invoice |
  26. +----------+-----------+-------+---------+
  27. | CU1      |    A3     | Date1 | I1      |
  28. | CU1      |    A3     | Date1 | I1      |
  29. | CU1      |    A3     | Date1 | I1      |
  30. | CU1      |    A3     | Date3 | I3      |
  31. | CU1      |    A3     | Date3 | I3      |
  32. | CU1      |    A3     | Date3 | I3      |
  33. +----------+-----------+-------+---------+
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top