 So it's Bali. This is the word of today, day four. Use this to mark your attendance. Okay, so let's go back to pivot table. So now that we have this kind of a table, and sometimes you would wish to know where is this Robin Premiers Health Centre coming from. Okay. We have because this this must have a parent which is the district and that district has belongs to a certain region, which a region is under the national level. So sometimes you would wish to have a report that clearly tells you the hierarchy, the entire hierarchy of the organization unit. How do you do that? Again, we go into options. Remember, we have this tab here type. This is where you could display the organization unit hierarchy. So under level, you just have to tick that. We are by ticking display organization unit hierarchy. That means the table is going to give you all the parents of the health facility that is displayed in this table here. And this is important, especially when you're giving out the data to people that probably they are not very much familiar with the organization unit hierarchy. So instead for them to struggle trying to link back where is this facility coming from? You could just display the organization unit hierarchy and it would be easy to connect back where do this facility belongs to. But with the table, we could always add a title. Okay. So that once you present the pivot table, at least it has a title that tells exactly what what is being displayed in the table. So you could add a table title which says let's say HIV. Yes. That's five years. If you click update, then our table now it's going to have to have a title. So apart from those, we also have other other functionalities that are vital under the style, style option. It could be managing the density of what is being displayed or even the font size as well as the digital group separator. So this is more or less to specify how do you want those thousands of data to be displayed after every three digits? What would you want to be a separator in between? So by default, it's usually the space, but instead of space, you could select comma or even choose to have none. So by saying none, if you click update, you would see the values are just closer to each other. But if I want a space between all those thousands of data, I could select space. By doing so, you'd see, OK, just after every three figures, I have a space. But sometimes I would wish to have comas instead of space. You always select comma. Then if you update, then you'd see your figures will have a comma to separate thousands of values. So apart from that, we have this functionality of fix column headers to top of the table or fix headers to, I mean, rows, headers to left of the table. When do you get to use this? These are mostly used especially when you have a very, very huge amount of data displayed at the table. Once you scroll that, you'd see those headers, they disappear. So I'll just go back here and update my organization unit. Instead of saying facility in the bad district, I'll just pull facilities within the entire country. So you'd see this kind of table. If I scroll to check the data below, it would be difficult for me to reference back these 338. I'm looking at what is this? Okay, because the headers here have disappeared. So if you want to freeze them, it's more or less like the way we freeze in the Excel, you come here under option style. It's a fixed column headers because the headers are in the column. So if I click update, that means I've moved here, you could see the headers of the columns have been freeze. So even if I scroll to the bottom of the table, I could still reference back the 5,025 figure that I'm looking at is for what? It's for the mail for the year 2018. So that applies to rows as well. If you have a very large amount of information, you could also freeze the rows. And if you scroll, they'll always stick there and you would be able to move around the other information, but still be able to link back what exactly are you looking at? So the display dimension, I've been an organization unit hierarchy. We have also looked at it where it's more or less to open up the parent of the selected organization unit. So that again, it's also easy to reference back where is that organization unit coming from? If it's a facility, what is the district that has that facility? Same applies to the region all the way back to the training land, which is the national level. So we have this kind of data. And it's very huge. Sometimes my interest, it's only to look at the data that range from 3,000, let's say to 5,000. But with the selections that I've just done here, I mean, it'll give me the data for all the facilities. But I need all the facilities, yes. But my interest is only to look at the facilities that have the data starting from 3,000 to 5,000. So how do I do that? Again, you can always go to the option. We have this limit values. This is where you get to define the range of values that you want to be displayed in a table. Of course, we always have the minimum value and the maximum value. And by saying 3,000 to 5,000, it means that I need all the facilities and for the HIV tests that have been done that have the value of 3,000, inclusive to 5,000 inclusive. If you want them to be not exclusive, again, you could always define it here. But OK, so the minimum value should be 3,000. That means you need 3,000 moving forward, 3,000 and more. So I would say greater than or equal to. They normally you get to define these ranges by using the normal mathematical operators. So since I need from 3,000 to 5,000, then it means it's the minimum value should be greater than or equal to. Then here's where you get to capture or specify the figure. I said it's 3,000. By just leaving it as it is, you would end up having beyond even if you had 10,000. But I also need to put up a limit for the maximum value. So if it's the maximum value should be 5,000, what should be the operator? That means it's less than or equal to 5,000. And I'll specify the maximum value. And if I click update, then parameters will not change in terms of for units, in terms of period and everything else, but rather it's just gonna filter out and present the data that fall within that range only. So you'd find probably an organization unit no longer here. Maybe it's because it has data that don't qualify in the specified range. So that is also you how you could limit the figures that are displayed in your pivot table. If you want to clear them, you could always go back to limit. And if you say clear maximum or minimum value and update, then it's gonna get rid of the ranges that we are set and retrieve back all the values that fall within the specified dimensions. Now we have seen how we can play around with these different functionalities, just to have a pivot table that actually meet our needs and have data that is very meaningful and easy to be interpreted or more or less to data that can easily tell you what is happening. What if I want to have this to use this information outside the system? You could always use the download functionality. And since it's a table, you could only download it in terms of Excel, CSV, which is more or less similar to Excel, but also HTML. Mostly used by the techie people. But again, we also have this plain data source. At what point do you use this kind of format? This is mostly used when you want to extract the information, but use it in other statistical software like SPSS, R, or Stata. So we could always use the download or extraction by using this plain data source. So that is how you could freeze the rows, how you could limit the range of values that are to be displayed in your table, and of course how you could show the hierarchies of these organization units that have been selected or displayed within the table. Now, using the table that we had created in a few minutes ago, let us go to that table, then update the facilities by showing the hierarchy. You need to display the hierarchy and filter the values to display only values that range between 2000 to 4000.