Jump to content
We've recently updated our Privacy Statement, available here ×

partial result as percentage of total


alca1

Recommended Posts

Let's say I have this data table:

{id_order, date_order}

I want to show the n. of orders in a period as percentage of the total number of orders.

I defined id_order as a countAll measure and date_order as dimension.

I used date_order as row and id_order as columns in crosstab report.

Next I added a filter on date_order: is between.

What I would like to show is just a box, with inside a BIG number with the percentage of orders against the total and below the period.

I tried to introduce a calculated measure PercentageOf ("id_order","Total") but it just works per row. (and even so number are not right)

I'm a bit lost, I don't how to do it nor I find relevant resources/examples

 

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...