Can anybody help me. I hve data with me. Now, i want 2 display the data in pivot table like the following description :
1. In 1st column i need to display the contents like Revenue & Expenditure.
2. When I clik the revenue it should show the sub fields of the revenue and hide the expenditure.
3. And when i clik the expenditure it should show the sub fields of the expenditure and when i clik the sub field of expenditure it should show the contents of particular sub field.
How can i do this and in which format i should create the database.
