11 Replies Latest reply on Sep 6, 2018 9:01 PM by Swathy k

# Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi,

I have attached the screenshot and the dataset, The result should look like the image attached, Unable to get an idea how to combine both actual and target sales and one single sale measure and show them separately on the chart.

Thanks,

Swathy

• ###### 1. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi Swathy,

You should start from reshaping the data source.

From edit data source

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi Shin,

I wanted to try without reshaping the data, that the challenge can we do it without reshaping the actual data.

• ###### 3. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Any particular reason you do not use data re-shaping?

There probably be other re-shaping method, but without any, I don't think that's reasonable request with Tableau.

Better use excel smply..

Shin

• ###### 4. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

I was trying some challenges online, and for this problem, it was mentioned that they haven't used the reshaping technique.

Note: I did not use any data reshaping technique for this chart. This chart builds with only 1 dimension and 4 measures.

Thanks again for the help

• ###### 5. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

I don't have idea.

But suspecting the definition of "I did not use any data reshaping technique for this chart. "

Anyways I probably miss something and if you could post the correct answer here, it' appreciated.

Thanks,

Shin

• ###### 6. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi Shin,

Please find the link for the challenge I was working on.

Thanks,

Swathy

• ###### 7. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi Swathy

If this is such kind of "QUIZ", there is an answer, but not typical.

I don't want to disclose the approach on this from with considering the intent of the blog writer.

But attached the final answer.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 8. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Thanks Shin.

• ###### 9. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi Swathy,

You are welcome.

If the post helped, please mark my answer as correct / helped to close the thread.

Not from inbox but from original post.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 10. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

HI Swathy k

If the post helped, please mark my answer as correct / helped to close the thread.

Not from inbox but from original post.

Thanks,

Shin

• ###### 11. Re: Can you Please help me in solving the below problem, I need to show sales and profit of the quarters.

Hi Shin,

Thanks, I have already done that.

Swathy