# Financial Statement Dimension wise **URL:** \ **Category:** User Forum\ **Created:** [January 11, 2013, 12:08pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863 "2013-01-11T12:08:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![shrinsam](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@shrinsam](https://www.dynamicsuser.net/u/shrinsam)\ **Post date:** [January 11, 2013, 12:08pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/1 "2013-01-11T12:08:31Z")
Dear All, Can any one help me guiding how to design Financial Statements Dimension wise in AX 2012. My design requirement is as below: column 1 : - Particulars column 2 : - Department dimension (value should print only department dimension) column 3 : - Cost center dimension (value should print only cost center dimension) column 3 : - Total column (sum of column 2 & 3) Please help …! Shrini ---
**Author:** ![Raaghav](https://avatars.discourse-cdn.com/v4/letter/r/8edcca/32.png) [@Raaghav](https://www.dynamicsuser.net/u/Raaghav)\ **Post date:** [January 11, 2013, 2:29pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/2 "2013-01-11T14:29:46Z")
Can you brief me your requirement with example ? Regards, Raghaav ---
**Author:** ![shrinsam](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@shrinsam](https://www.dynamicsuser.net/u/shrinsam)\ **Post date:** [January 13, 2013, 5:56pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/3 "2013-01-13T17:56:20Z")
Hi Raghaav, Actually I want to print P&L and Balance Sheet statements values dimension wise, for example": **Column1 Column 2 Column 3 Column 4 Column 5** **Particulars Department Cost Centre Purpose Total** Sales income 100000 100000 ------ 100000 Other income 50000 50000 ------ 50000 Admin exp’s 15000 15000 15000 15000 Selling exp’s 10000 10000 10000 10000 Finance exp’s 5000 5000 5000 5000 * * * Profit/(Loss) (120000) (120000) 30000 (120000) I hope you will understand the above example and suggest better solution. Shrini ---
**Author:** ![tFabrio](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@tFabrio](https://www.dynamicsuser.net/u/tFabrio)\ **Post date:** [January 13, 2013, 11:04pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/4 "2013-01-13T23:04:29Z")
To start off, I believe, you have to set the primary dimension set (which should contain DEPT, Cost Center, Purpose) and use secondary dimension set as Main-Account Set. this is assuming you have these dimensions defined in the account structure 2nd, define the row definition structure and reference this in the financial statement. ---
**Author:** ![Honey1806](https://avatars.discourse-cdn.com/v4/letter/h/7993a0/32.png) [@Honey1806](https://www.dynamicsuser.net/u/Honey1806)\ **Post date:** [March 7, 2013, 10:00am UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/5 "2013-03-07T10:00:02Z")
Hi patrik, I have one requirement in which i have to hide / disabled some financial dimensions from the default list from customer master form. How can I do that ? Anuj ---
**Author:** ![vimalsingh](https://avatars.discourse-cdn.com/v4/letter/v/7ea924/32.png) [@vimalsingh](https://www.dynamicsuser.net/u/vimalsingh)\ **Post date:** [May 9, 2013, 12:44pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/6 "2013-05-09T12:44:01Z")
Hello Patrick, I have a problem during opening of P&L statement Dimension wise (Department & Cost center) but it takes a lot of time to open and lastly (after 3-4 hours) it has been denied to open. Reference for input: I have also checked in another localization but faced same problem. Please suggest me a apposite solution. Thanks a lot. Vimal ---
**Author:** ![tFabrio](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@tFabrio](https://www.dynamicsuser.net/u/tFabrio)\ **Post date:** [May 16, 2013, 5:10pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/7 "2013-05-16T17:10:13Z")
If you have Management Reporter, then I would consider for getting dimension based report - its little better, AX client tend to take time with dimensions. I can’t see the output you are referring to. ---
**Author:** ![tFabrio](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@tFabrio](https://www.dynamicsuser.net/u/tFabrio)\ **Post date:** [May 16, 2013, 5:11pm UTC](https://www.dynamicsuser.net/t/financial-statement-dimension-wise/42863/8 "2013-05-16T17:11:29Z")
Do you want to hide/disable for all? where do you intend to see this disabled? which form?