14 Replies Latest reply on Apr 4, 2016 5:11 AM by koushik.neelakantha

Hello All,

I need to show the rectangle box.

Logic:

à\$29.7M to go to YTD FBP= 74.9 -39.6(IBP - Local Sales)

à\$35.3M to go to YTD IBP=69.3-39.6( FBP- Local Sales)

Note : IBP and FBP made cumulative in Database itself. Local sales cumulative we made it in tableau(taking running Total).

Regards,

Koushik.

Hi,

For the rectangle box what I'm thinking you should create a string calculated field and put it in a worksheet. Format the grid of that sheet. If your text is coming from any calculated field then concatenate the calc field with your text.

Then in your dashboard you can drag a floating container and drag that sheet by holding shift, hide the title of the sheet.

you can drag your measures/calc measures and put in label and play with the alignment part.

Mahfooj

Hello ,

My concern is..i need logic for the cumulative difference.

Example: I have 2 KPI's - FBP and sales. Cumulative for FBP calculated in database itself and for sales I have taken running total in tableau.

My concern is that, I need to subtract FBP(cumulative) and Sales(Cumulative) . Kindly let me know the logic.

(Difference between two measures with cumulative.)

Regards,

KOushik

Kindly share some sample data with the workbook. It will be more helpful for us.

Hello,

here Cumulative for FBP is done in Database itself and cumulative for sales done in tableau.

For Day 19, my FBP cumulative is 2850113 and cumulative for sales is 2616897.

I need to calculate difference between fbp cumulative and sales cumulative so that i should get 233216 for day 19 ans so on...

Regards,

Koushik

Try this!

What I've done is created a calc field and drag it in tooltip.

I think this is what you wanted.

Hello mahfooj,

Thank u for the reply. I created the same calc field with the same logic.

and my another concern is.

For suppose if my FBP is present  till D23 is 80 and I have sales till D 14 ie, 60.

I need to calc the difference. FBP till 23- sales till D 14(without Hard coding).

Regards,

Koushik.

Hello,

In short, I need to calculate difference for max day num for FBP and max day num for Sales.

Regards,

Koushik

See the attached workbook(version 9.2).

I've created few calc fields to calculate that. Have a look.

Let me know if you've any doubt.

Lets assume this is the data. All the calculation have been made as per below data.

sorry unable to open this workbook because we are using version 9.0

can u send me the same with ver 9.0 or else kindly send me the calculation logic.

Regards,

Koushik

Have to create five calc fields

1st

2nd

3rd

4th

and 5th for diff

that's it.

Just drag your calc fields as per below screen shot. your view will be like this.

Mahfooj

In my case, cumulative for FBP is calculated in the ETL itself. for sales we are doing running sum.

what images would be the better option for the above scenario.

Regards,

Koushik

Hello Khan,

I have day num till 23..my sales are not present for Day 21,22 and 23 .Taken a bar chart.

I am getting correct cumulative values till D20, but for Day 21,22,23 I am getting  Day 20 values for Day 21,22,23.

I should not get like that..i need to get zero for Day 21,22,23.( because my sales are not present for those)

Kindly help me.

Regards,

Koushik.