Answers.Body: <p>You can search for expenses using SearchKit, which will allow you to sort and display them any way you desire.</p>
  <p>Note that each Expense is broken out into one or more Expense Lines. The Expense stores the date, type, status, etc. and the expense line stores the amount. Depending on how you want to display them, you can use either as the basis of the search and then add (&quot;With&quot;) the other. Here is an example search of Expenses WITH Expense Lines:</p>
  <p><a href="https://i.sstatic.net/fzW1S.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/fzW1S.png" alt="Expenses Search" /></a></p>
  <p>There is much more you can do with SearchKit, including grouping, filtering, and multiple ways to create a display, but this should get you started. For more general documentation on SearchKit, see <a href="https://docs.civicrm.org/user/en/latest/searching/searchkit/what-is-searchkit/" rel="nofollow noreferrer">https://docs.civicrm.org/user/en/latest/searching/searchkit/what-is-searchkit/</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-26T04:05:30.117Z
Answers.Text: Thanks for your replay. I do not have with (optional) Expense Exepense Lines. Please see screenshot  https://ibb.co/K6xwMv0 Thank you
Answers.UserDisplayName: Calgary
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-26T13:01:18.233Z
Answers.Text: In your screenshot, I see that SearchKit is non-functional because something is wrong with your site's theme. None of the dropdowns will work unless you enable Greenwich or another Bootstrap-enabled theme.
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-27T13:11:07.500Z
Answers.Text: I changed theme. But still there is no option "With (optional) Expense Expense Lines"  https://ibb.co/P4gyF4B
Answers.UserDisplayName: Calgary
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-28T16:33:17.450Z
Answers.Text: Curious, it seemed to work for me. Are you logged in as an administrator and do you have the `'manage expenses'` permission?
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-25T00:23:57.267Z
Answers.LastActivityDate: 2023-08-25T00:23:57.267Z
Answers.UserDisplayName: Coleman
Body: <p>I use the <a href="https://civicrm.org/extensions/expenses" rel="nofollow noreferrer">Expenses extension</a> to keep tracking expense in my organization.
  It was ok when we had only few entries. But now we have more than 40.
  Is it possible to show newest on top and oldest on bottom...how do i sort out that?
  Thanks</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-08-22T16:32:02.067Z
Comments.Text: Have you tried SearchKit?
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-08-24T16:26:26.443Z
Comments.Text: No i did not. Is it possible to do that?
Comments.UserDisplayName: Calgary
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-08-24T17:39:23.930Z
Comments.Text: I tried. But there is no option to display total amount.
Comments.UserDisplayName: Calgary
Tags: <display>
Title: Sort (display) expense
ThreadText: # Sort (display) expense
  
  (Asked by: username_0 on 2023-08-22)
  
  I use the [Expenses extension](https://civicrm.org/extensions/expenses) to keep tracking expense in my organization.
  It was ok when we had only few entries. But now we have more than 40.
  Is it possible to show newest on top and oldest on bottom...how do i sort out that?
  Thanks
  
  **Tags:** display
  
  > **Comments:**
  > **username_1**: Have you tried SearchKit?  
  > **username_0**: No i did not. Is it possible to do that?  
  > **username_0**: I tried. But there is no option to display total amount.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-08-25. Score: 0
  
  You can search for expenses using SearchKit, which will allow you to sort and display them any way you desire.
  
  Note that each Expense is broken out into one or more Expense Lines. The Expense stores the date, type, status, etc. and the expense line stores the amount. Depending on how you want to display them, you can use either as the basis of the search and then add ("With") the other. Here is an example search of Expenses WITH Expense Lines:
  
  [![Expenses Search](https://i.sstatic.net/fzW1S.png)](https://i.sstatic.net/fzW1S.png)
  
  There is much more you can do with SearchKit, including grouping, filtering, and multiple ways to create a display, but this should get you started. For more general documentation on SearchKit, see <https://docs.civicrm.org/user/en/latest/searching/searchkit/what-is-searchkit/>
  
  > **Comments:**
  > **username_0**: Thanks for your replay. I do not have with (optional) Expense Exepense Lines. Please see screenshot  https://ibb.co/K6xwMv0 Thank you  
  > **username_1**: In your screenshot, I see that SearchKit is non-functional because something is wrong with your site's theme. None of the dropdowns will work unless you enable Greenwich or another Bootstrap-enabled theme.  
  > **username_0**: I changed theme. But still there is no option "With (optional) Expense Expense Lines"  https://ibb.co/P4gyF4B  
  > **username_1**: Curious, it seemed to work for me. Are you logged in as an administrator and do you have the `'manage expenses'` permission?  
  
  ---
  
  