Dimension Format

[sona_sa]

Hello Team,

I have a Profit & Loss qvw application, There is two Pivot Table. 1st One without YearMonth dimension, That Format is correct. Means

ADMINISTRATIVE & SELLING EXPENSES

TOTAL ADMINISTRATIVE & SELLING EXPENSES

Advances Recoverable In Cash Or In Kind For The Value To Be Received

Total Advances Recoverable In Cash Or In Kind For The Value To Be Received

Total

All these are in bold and Value is also in bold. But in 2nd Pivot I am using one more dimension, i.e is YearMonth. But when I am using 2nd dimension then my format is changed. But I need same format  which is 1st One.

For more reference please find the attached QVW.

Thanks.

[SergeyMak]

Hi,

I see that by some reasons you don't have 'c' value for all of the Year-Month, that's why Only([Exec P&L Heading ]) will give you Null(), but not 'c'. You can reach the goal if you rebuild a data model a bit, It's a bit strange from my point of view.

Regards,
Sergey

PFA to see what I've found

[sona_sa]

Hi,

Is there any another option. Or also please let me know what type of changes I have to do in data model.

Thanks for reply.

[sujeetsingh]

I recommend you to use a small trick if the number of the headings is fixed\static use transparent text boxes with the same labels

[sona_sa]

Hi

I also tried by :

=If(([P&L Heading]='Assets' or

[P&L Heading]='Current Assets'or

[P&L Heading]='Cash and Cash Equivalents' or

[P&L Heading]='Total Cash and Cash Equivalents') and [P&L Calculation] = 'c','<B>')

But no any effect.

Thanks.

[SergeyMak]

To be honest, you have pretty strange P&L, because you have only Expenses in some month

ADMINISTRATIVE & SELLING EXPENSES

LOSS DUE TO THEFT

PRIOR PERIOD EXPENSES

REGISTRAR & TRANSFER EXPENSES

SUNDRY BALANCE (W.OFF)

TOTAL ADMINISTRATIVE & SELLING EXPENSES

And

these type of transactions in other months

Advances Recoverable In Cash Or In Kind For The Value To Be Received

Advance (For Exp.)

Checks Received Clearing

Travelling Advance (Saumil Munshi)

Travelling Advance

Total Advances Recoverable In Cash Or In Kind For The Value To Be Received

And I didn't find any month where they are together...

How it's possible?

I see that you formatting is working fine if you select one month or several moth but with only First or Only second type of transactions.

Probably you've got this after

IntervalMatch:
INTERVALMATCH ([Reporting Code]) LOAD 
ExecPLStart,
ExecPLEnd
RESIDENT ExecProfitLoss;

It's unclear for me, why did you do it..

I optimised a data model, but it didn't solve the main issue

PFA

[sona_sa]

Thanks for reply Sergey.

I used the same. But there is one more problem and still the main output is also not coming. In YearMonth there is one more null colum is coming.

Please revert for any clarification. Also on the selection of Yearmonth it is not coming.

Thanks

[sona_sa]

Hello

Any Hope for the same.

Thanks.