calculated column

  1. M

    Add calculated column

    I have a pivot table that display reference cost by week, like above : <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif...
  2. S

    Pivot Table - Calculating Percent of Cost Type In Column next to Grand Total

    I have a pivot table and I want to create multiple columns that will end up like the table below (on the right, left is sample data). My data has date processed for each line so I can do a date sort, but I can only do one column at a time(e.g. rent, then copy it, then resort the table for grand...
  3. G

    Measure used in Calculated Column

    I am having some trouble working out what I am doing wrong... I have a measure called Markup - Markup:=[Ext Margin]/[Ext COGs] I am then trying to use this measure in a calculated column which is =if([RevenueType]="Internal",([Markup]+1)*[Tran Amt],0) Any help will be appreciated! Thanks!
  4. J

    New columns - true or false if duplicate value

    Hello, I'm looking for a simple calculated column formula to give me true/false (or -1/1) if a row's value is duplicated within a column. Basically, I have a column with many values that are repeated in it, and I want a new column telling me if each row has a duplicate value in the original...
    • jk-vtti
    • Thread
    • calculated column column count duplicate
    • Replies: 8
    • Forum: Power Tools
  5. A

    PowerPivot Calculated Column to find an Approximate Match

    Hi - I'm new to PowerPivot and DAX and I am trying to create a calculated column in PowerPivot. The calculated column should be similar to using VLOOKUP with TRUE as the Range_Lookup to find an approximate match where VLOOKUP will find the exact value or the next largest value that is less...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top