Greetings SDN community. i have a report specification which is similar to this;
customer a 999.00 9 1
customer b 99.00 2 1
in determining whether an account should fall under water or sewer, i use a keyfield, 'rate'. if rate = 01, it will fall under 'water. if rate = '02', it will fall under 'sewer'.
where should i build this condition or formula so that each customer should fall under their respective categories.
You have to restrict the Key Figure with Rate right click on the Key Figure.and click on Restrict.Then Restrict Rate with 1. Drag and drop another Key Figure and restrict this on Rate with 0. Keep 2 names for the same key figure.
Let me know if not clear