New to (Power)Pivot world, task looks simple, but...

[IvanR]

I am from db world and beginer in (Power)Pivot world...

I have two data tables (views in sql server):

Table 1, aggreagaton of Clients: (ClientType, NoOfClients)

ClientType	NoOfClients
ct1	100
ct2	200
ct3	50

<tbody>
</tbody>

Table 2, aggregation of casses: (ClientType, attribA, attribB, attribC, ... AttribH, NoOfCasses) - about 10 attributes, only 3000 rows...

ClientType	attribA	attribB	attribC	NoOfCases
ct1	a1	b1	c1	50
ct1	a1	b2	c1	20
ct1	a1	b2	c2	10
ct2	a2	b1	c1	52
ct2	a2	b2	c1	22
ct2	a3	b2	c2	12
ct3	a1	b1	c1	5
ct3	a2	b2	c1	6
ct3	a3	b2	c2	7

<tbody>
</tbody>

I have to create identical reports, number of reports is equal to number of attributes – 10.

	Rows	Column1	Other columns (value is Sum of NoOfCasses)
ReportA	ClientType	NoOfClients	a1, a2, .., an
ReportB	ClientType	NoOfClients	b1, b2,..., bn
Report...	...
ReportH	ClientType	NoOfClients	h1, h2,..., hn

<tbody>
</tbody>

Example report:

ClientType	NoOfClients	a1	a2	a3	Total Cases
ct1	100	80			80
ct2	200		74	12	86
ct3	50	5	6	7	18
Grand Total	350	85	80	19	184

<tbody>
</tbody>

When management asked for first report i made it manual. When they asked for these set of reports, it is time for BI…
It looks simple, but pivot beginner is struggling to make it…

Thanks for any help, guideline…

Ivan