00:00bismillahirrahmanirrahim
00:02السلام علیکم
00:03learning with amdorzy
00:04میں خوشحامدید
00:04آج کے اس لیکچر میں
00:06ہم پیورٹ ٹیبل کی کچھ
00:08اگزیمپلز کو سیکھیں گے
00:09جس کی مدد سے
00:10ہم یہ جان سکیں گے
00:11کہ پیورٹ ٹیبل کو
00:12افیکٹیوی کس طریقے سے
00:14استعمال کیا جا سکتا ہے
00:15ساتھ یہ پیورٹ ٹیبل فیلڈ میں
00:16جو ایک option
00:17filter کی تھی
00:18اس کو بھی ہم
00:18apply کر کے دیکھیں گے
00:20کہ اس کو ہم
00:21اپنے ڈیٹا میں
00:22We can use it on the computer screen.
00:24Let's go to computer screen.
00:26We can learn how to use our data
00:28with the pivot table
00:30to easily
00:32reports and data
00:34generate
00:36which can be very effective.
00:44We are going to computer screen.
00:46This is the data
00:48which we have used last lecture
00:50which we can use.
00:52We can use this data
00:54with the pivot table
00:56to summarize.
00:58First, insert pivot table
01:00range selects
01:02existing worksheet
01:04and this place
01:06OK.
01:08We want to make
01:10the data
01:12region-wise
01:14row
01:16region-wise
01:18we have
01:20sales
01:22and
01:24we have
01:26numbers
01:28and
01:30here
01:32number
01:34and
01:35use
01:36thousand
01:38here.
01:40We have
01:42region-wise
01:43central
01:44we have
01:4617,700
01:47north
01:4821
01:49south
01:5014,000
01:51plus.
01:52we have
01:54we have
01:56we have
01:58to
02:00select
02:02we have
02:04to
02:06we have
02:08to
02:10we have
02:12to
02:14to
02:16see
02:17the
02:18number
02:19we have
02:20to
02:21see
02:22how
02:23we
02:24can
02:25see
02:26how
02:27we
02:28can
02:29see
02:30how
02:31we
02:32can
02:33see
02:34how
02:35change
02:36because
02:37this
02:38is
02:39difficult
02:40because
02:41this
02:42is
02:43difficult
02:44here
02:45we have
02:46here
02:47to
02:48design
02:49tab
02:50report
02:51layout
02:52compact
02:53by default
02:54outline
02:55form
02:56here
02:57region
02:58name
02:59tabular
03:00form
03:01tabular
03:02form
03:03here
03:04central
03:05total
03:06here
03:07here
03:08here
03:09here
03:10and
03:11left
03:12side
03:13here
03:15here
03:16subtotal
03:17at
03:18bottom
03:19of
03:20group
03:21show
03:22all
03:23subtotal
03:24at
03:25top
03:26of
03:27group
03:28tabular
03:29form
03:31here
03:32we
03:33outline
03:34form
03:35here
03:36show
03:37here
03:38if
03:39bottom
03:40will
03:41top
03:42will
03:43be
03:44top
03:45here
03:46here
03:47here
03:48here
03:49here
03:50we
03:51want
03:52to
03:53cost
03:54of
03:55good
03:56sold
03:57and
03:58maximum
03:59data
04:00here
04:02cost
04:03of
04:04good
04:05sold
04:06here
04:07cost
04:08of
04:09good
04:10sold
04:11here
04:12maximum
04:14and
04:15minimum
04:16minimum
04:17of
04:18sale
04:19sale
04:20sale
04:21sale
04:22some
04:23of
04:24sale
04:25to
04:26click
04:27value
04:28here
04:29sum
04:30to
04:31count
04:32to
04:33count
04:34of
04:35sale
04:36to
04:37sum
04:38of
04:39sale
04:40count
04:41of
04:42sale
04:43now
04:44we
04:45do
04:46again
04:47sale
04:48to
04:49sell
04:50some
04:51of
04:52sale
04:53to
04:54fill
04:55here
04:56we
04:57have
04:58average
04:59of
05:00sale
05:01to
05:02sell
05:03here
05:05we
05:06have
05:07sum
05:08of
05:09sale
05:10to
05:11fill
05:12setting
05:13this
05:14maximum
05:15max
05:16of
05:17sale
05:18okay
05:19one
05:20one
05:21more
05:22sale
05:23we
05:24do
05:25some
05:26of
05:27sale
05:28to
05:29here
05:30minimum
05:31this
05:32off
05:33okay
05:34now
05:35here
05:36data
05:37is
05:38central
05:39total
05:404
05:41count
05:42average
05:43sale
05:44minimum
05:45sale
05:46of
05:47good
05:48sold
05:49here
05:50this
05:52central
05:53has
05:54two
05:55north
05:56total
05:57total
05:58and
05:59south
06:00in
06:01the
06:02total
06:03total
06:04total
06:05total
06:06total
06:07total
06:08total
06:09total
06:10total
06:11total
06:12total
06:13total
06:14total
06:15two
06:16difficult
06:17bandit
06:18rose
06:19and
06:20columns
06:21we
06:22can
06:23just
06:24group
06:25center
06:26north
06:27highlight
06:28this
06:29we
06:30have
06:31added
06:32columns
06:33here
06:34we
06:35have
06:36to
06:37center
06:38line
06:39to
06:40center
06:41line
06:42after
06:43each
06:44item
06:45center
06:46after
06:47each
06:48item
06:49center
06:50after
06:51each
06:52item
06:53center
06:54after
06:55center
06:56and
06:57center
06:58and
06:59south
07:00down
07:01after
07:02each
07:03center
07:04after
07:05center
07:06after
07:07center
07:08and
07:09south
07:10after
07:11now
07:12we
07:13have
07:14the
07:15center
07:16group
07:17two
07:18joints
07:19were
07:20separate
07:21total
07:22total
07:23and
07:24total
07:25total
07:26bottom
07:27we
07:28can
07:29make it
07:30confusing
07:31because
07:32blank
07:33rows
07:34add
07:35central
07:36total
07:37total
07:38total
07:39total
07:40total
07:41total
07:42total
07:43total
07:44total
07:45total
07:46total
07:47total
07:48total
07:49total
07:50total
07:51total
07:52column
07:53set
07:54total
07:55all
07:56in
07:57the
07:58section
07:59and
08:00the
08:01section
08:02is
08:03the
08:05section
08:06that
08:07we
08:08had
08:09a
08:10different
08:11section
08:12of
08:13the
08:14section
08:15of
08:16the
08:17section
08:18date column
08:20date wise we want to remove data
08:24date we add here
08:26central date
08:28then we will add one column
08:30we will add date
08:32we will add date
08:34we will drag
08:36and filter
08:38date
08:40we will add date
08:4227 data
08:44north
08:46date
08:48date
08:50multiple dates
08:52select multiple items
08:54select multiple items
08:56select filter
08:58this option
09:00select
09:02now
09:04if we give
09:06any data
09:08we will add
09:10and
09:12If you have any kind of confusion, you can share it with me.
09:16Here is our lecture today.
09:18I hope you will understand that the pivot table is a good way to understand.
09:22In the next lecture, Inshallah, my pivot chart will be very flexible.
09:28You can see the chart in the future.
09:32In the next lecture, you can see the pivot chart in the future.
09:36You can see the pivot chart in the future.
09:40Inshallah, the next lecture will be the pivot chart in the future.
09:43We will see you in the next lecture.
09:44I hope you will see you in the next lecture.
Comments