cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nagaraj007 Regular Visitor
Regular Visitor

Need to show Description in One Column based on Ledger Account

Hello All,

I need to show Description based on Ledger Account in one column. Please advice how to do this 

 

Ledger Description
4002310 Staff Cost
4002311 Staff Cost
4002312 Staff Cost
4002313 Staff Cost
4002314 Staff Cost
4002315 Staff Cost
4002316 Staff Cost
4002317 Staff Cost
4002318 Staff Cost
4002319 Operational Cost
4002320 Operational Cost
4002321 Staff Cost
4002322 Staff Cost
4002323 Staff Cost
4002410 Staff Cost
4002411 Staff Cost
4002412 Staff Cost
4002413 Staff Cost
4002414 Staff Cost

 

5 REPLIES 5
yazidh Regular Visitor
Regular Visitor

Re: Need to show Description in One Column based on Ledger Account

do you mean you want to concatenate the two in one column? can you please elaborate on the requirement?

nagaraj007 Regular Visitor
Regular Visitor

Re: Need to show Description in One Column based on Ledger Account

Hi,

I would want to add one column as Description which will calculate based on ledger column.

 

For ex. : if the column has 4002310 the new column should show as Staff Cost

yazidh Regular Visitor
Regular Visitor

Re: Need to show Description in One Column based on Ledger Account

You can add a "Conditional Column" for that, something like this 

nagaraj007 Regular Visitor
Regular Visitor

Re: Need to show Description in One Column based on Ledger Account

I need to add 20 line items in Conditional formatting. Is there any way i can add all 20 items in conditional formatting based on my data?

yazidh Regular Visitor
Regular Visitor

Re: Need to show Description in One Column based on Ledger Account

Then i believe you could have a master table built for this purpose, and then you can lookup the value from it,

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)