Hello everybody, welcome back to dashboard. In this video we will see how to create a slab report. And once again we'll be creating a copy of the same pivot table so that the pivots that we are creating are connected to the same master data. So we will hold on the Ctrl key drag and drop as a third pivot. So I'll just change the name to pivot three. And I'll be deleting the chart for now.
So here I'm planning to create a slab report. So a salary wise slab or salary is given to what experienced person but the question over here is our data has unexperienced option. There are some na values. Now let me explain what the problem is. So I'll just remove all the fields. So I will drag and drop in the salary in US dollars.
That is the total and they experience that is the yearly experience in the role label. And as we can see the Extreme bottom of the table data there is value called not applicable. Not Applicable is where the conditions are not to be met. But if I try to right click and try to group it now. Now that's a feature already mentioned in a previous video is applicable to two data sets. One is date and the other is number and once I tried to group it, it says the group cannot be possible because there is a text value which cannot be grouped.
So to do So first, I have to update my data. So I'll just filter the data and I'll just convert these values to zero. And so once converted into the data, I'll just clear the filter. Now my data has been updated, and I just have to redo the process. So right click, and I refresh the data. And as soon as I do that, now there are no values as such.
Now let's see the output and when I right click and group it this time does not give me an error and it brings up the data directly. Now I can have a slab report because the numbers are grouped into slabs. The first condition, what is the start with the smallest possible number and I will start with zero. And at the end by default the system takes the biggest number here as of now it's 40. And we can go for an even bigger number. So the 40 years is the maximum experience.
I will go with 50 as my deadline, then need the interval was a gap between the slabs so I'll go with five years of gap or gapping between the experience Okay, now keep it as zero. And once done, just click on OK. And the slab reports are ready. Isn't that cool? Now if you wish to have a 10 year gap, it is also simple enough just have to change the five to 10. And there it is. There might be a question.
It's a Zero 1010 to 2020 to 30. So the numbers are getting repeated. But don't worry, this is because there are decimals and if there are no decimals, the next slab will always start from 11. So because of the decimal problem, there's a decimal, the first variable is actually from 10.5. And the next one is from 10.6. So that's how the slab is divided.
Once done, that is the total salary just keep it as it is, once again, alt f1 to create the chart. And this time as we are just providing slab reports as in sections and groups, so we are planning to prepare the data so we'll make a pie chart. So we will make a pie chart. So this will be right click on the chart and change the chart type pie diagram now go with 3d pie. So that gives us an overview of how the data looks. Now to make the data even better, we can simply go and click on the brush icon to format it.
And we can also use the plus sign That his chart elements, which is also called Layout option, and which is provided as a plus just next to the chart from 2013, then layout that is data label data call out. Once done simply we can delete any parameter that is not here. Now I'll just shift this to a little bit to the right. And that should do it. So here's our third chart. So just to recap, now we have three pivots with three different reports being generated, but all coming from the same data.
Now comes the climax for the first dashboard. In the next video, we'll be seeing how to club all these charts into one screen and make a final dashboard and use some buttons to control it. Till then keep practicing. See you in the next video. Thank you