Advance/Complex Table pivot or filtering need

*	*	M.bed	M.bed	M.bed	C.bed	C.bed	C.bed	G.bed	G.bed	G.bed	G.bed	*
Apt	Floor	commod	basin	Light	basin	commod	basin	commod	basin	light	Soap	Status
A	1	3	3	2	4	1	3	5	4	2	3	unsold
B	1	4	2	5	3	1	4	4	4	1	3	unsold
A	2	4	1	0	0	4	1	2	1	2	1	L/O
B	2	4	1	4	0	0	3	5	4	3	4	L/O
A	3	3	2	2	2	2	2	5	3	3	4	unsold
B	3	1	1	4	2	1	1	4	1	4	4	sold
A	4	3	3	3	1	1	2	1	0	2	2	L/O
B	4	2	5	1	5	2	3	3	1	4	4	L/O
A	5	4	1	3	1	1	0	3	5	5	2	L/O
B	5	4	5	1	2	1	1	3	3	3	1	unsold

This is my table. Now I want belo report
1. Total commode
2. Total Basin
3. Total Light
4. Total Basin in Apt-B
5. Total Basin for L/O status
6. Total Basin for M.Bed
7. Total Commod for Apt-B of M.Bed
8. Total Basin for Apt-b of Sold status
9. Total Basin for Apt-A of C.Bed of L/O status
10. Total Basin for Floor 4
11. Total Basin for Apt-A of L/O

is it possible in excel ?

Re-arange your table in a verticaly way.

After that you are able to use a pivot table, to analyze your data.

Isn't it funny how most things are solved by rearranging or standardizing the data?

This is one possible solution using your present data setup using a pivot table. The column headers were modified to include the top row into the second row.