title: Dividing data -cache
body: <p>[report]<img src="https://i.stack.imgur.com/BfPMq.jpg" alt="1" /></p>
  <p>the attached code shows the result of each ward and it works well. I want just to divide the 5c ward into two wards in the report while it is one ward in the system. this ward is a mixed ward(5c) and I want to calculate the beds differently. I want to separate the beds of the 5c ward into two wards (5c-pediatric which has the first 6 beds of 5c and 5c-surgery which has the last 6 beds of 5c). I tried but I could not.</p>
  <p>the the below shows each ward data. the desired report is to divide only 5c ward into 2 wards, we differeante the beds by the name if the bed name has pediatric means belong to pediatric and if the bed name has surgey means the bed belong to surgey</p>
  <p>[the output of report]<img src="https://i.stack.imgur.com/byMto.png" alt="2" /></p>